ISERROR in Excel fails when using an array

by

When using the formula ISERROR in Excel, I get unexcepted results when using the formula with an array (in this example A2:A11).

Excel sheet

Excel sheet with formula

  • It wont fail add + in front of A2:A11, also what I found it does works without + in the updated version of MS365 See here

    – 




  • implicit intersection

    – 

  • @SpectralInstance if i am not wrong @ Implicit Intersection operator returns the top left value of an array where as OP is looking to return an array, will you please let me know how is this related, it will help that is why i am asking. As per MSFT it returns top left cell of an array.

    – 




  • @MayukhBhattacharya the @ operator is applicable with dynamic arrays but, from the screenshots provided, where the ‘array formulae’ only return a single result, it seems that the OP does not have such

    – 




  • 1

    @MayukhBhattacharya in the OP’s screenshot (only) the ISERROR() function is returning FALSE re the #DIV/0 error, which is what I find anomalous

    – 

Leave a Comment