Hi, I am trying to put a formula with a combination of ISERROR and ISNUMBER as follows:
=IF(ISERROR(A2),IF(B2<10,"South",IF(B2>=10,"North",IF(ISNUMBER(A2),IF(C2<20,"South","North")
Getting result for the error values but not for the number values. Seems some issue in the logic. Solicit your help in resolving this
Regards
Amiya C
=IF(ISERROR(A2),IF(B2<10,"South",IF(B2>=10,"North",IF(ISNUMBER(A2),IF(C2<20,"South","North")
Getting result for the error values but not for the number values. Seems some issue in the logic. Solicit your help in resolving this
Regards
Amiya C