Hi all, I have the below formula in cell N16
=IFERROR(INDEX(P16:IK16,MATCH(9.99999999999999E+307,P16:IK16)),"No Data")
the outcome of the formula is No Data
in cell F14 I have the number 4
In a separate cell, I have the following TRUE / FALSE statement =N16>F14
the answer I'm getting is TRUE. So my question is why do I get the answer TRUE ? I'm not understanding why "No Data" (in cell N16) is considered greater than 4 (in cell F14).
=IFERROR(INDEX(P16:IK16,MATCH(9.99999999999999E+307,P16:IK16)),"No Data")
the outcome of the formula is No Data
in cell F14 I have the number 4
In a separate cell, I have the following TRUE / FALSE statement =N16>F14
the answer I'm getting is TRUE. So my question is why do I get the answer TRUE ? I'm not understanding why "No Data" (in cell N16) is considered greater than 4 (in cell F14).