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 ...
It works on Excel which doesn't support dynamic arrays, and doesn't work on Excel with dynamic arrays.
It looks like IFERROR() returns an error if element of the array is more than 255 characters length. If you work with one element (or, the same, without dynamic arrays) it takes only one element. If you convert the range into array another logic works, function consider elements with <= 255 characters only.
You may test
=IFERROR(LEFT(B3:B4,255),"error") - works
=IFERROR(LEFT(B3:B4,256),"error") - doesn't work