Forum Discussion
IFERROR reads a long text as Error when Input is a Range
For some reason, IFERROR function seems to be reading (registering) a long text as an Error when the input is a range of cells. It works fine if the input is a single cell. I don't know if it is due ...
Why use IFERROR() in the first place? There is no error in a text string.
Just =B3:B4 works fine.