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 ...
The limit is 255 characters. 255 is the largest number that fits into 1 byte (8 bits); it is a limit that occurs in many places in Excel.
You already know how to avoid it: use =IFERROR(B3,"Error!!") and fill down.
Oops, coming late