IF_true/false

**Azam Ali** · 07-15-2011, 03:12 AM

No. dont omit >0; becouse it is checking the existance of "Fail" in the range

break the function and evaluate. this may help in understanding. e.g

in one cell say S11 first look at the result of =MATCH("Fail",K11:P11,0)
then in next cell T11 look at =IF(S11>0,"Fail","")
then in next cell U11 look at =IFERROR(T11,"")

copy paste these from row 3 to row 11.

**cicihk** · 07-15-2011, 03:37 AM

Originally Posted by Azam Ali

No. dont omit >0; becouse it is checking the existance of "Fail" in the range

break the function and evaluate. this may help in understanding. e.g

in one cell say S11 first look at the result of =MATCH("Fail",K11:P11,0)
then in next cell T11 look at =IF(S11>0,"Fail","")
then in next cell U11 look at =IFERROR(T11,"")

copy paste these from row 3 to row 11.

Clear.. Thanks much again!!