IF_true/false

Originally Posted by Azam Ali

hi cicihk

first the match function is giving the column numbre if Fail is found in the range. that number >0 will give result true if there is a fail in the range.

an if true if function give result "Fail"

Azam Ali,
ic. will it be ok if I omit ">0" in the function?