https://bugs.documentfoundation.org/show_bug.cgi?id=146377
--- Comment #2 from Paul den Hollander <[email protected]> --- (In reply to Werner Tietz from comment #1) > Hallo > it looks like `IFERROR` in second Formula "controls" the whole > evaluating-chain, no matter its own position, regardless the very uncommon > Formula I would call it a bug. Yes, I've tested IFERROR in other formulas, and unexpected things happen there too. So it's not just in IF. An example: =AND(NA();1) =AND(NA();IFERROR(NA();1)) Result of first formula is #N/A, result of second is Err:504. Basically IFERROR can affect the handling of errors that do not originate in it's parameters. This also seems to happen with the IS* functions, like ISTEXT, ISNA, etc. E.g.: =AND(NA();IF(ISNUMBER(1);1)) Results in Err:504 -- You are receiving this mail because: You are the assignee for the bug.
