Result displays "FALSE" instead of "FAIL"

F

Formula error

=IF(J13="PASS",IF(I13>=60,"FIRST CLASS",IF(I13>=50,"SECOND
CLASS",IF(I13>=35,"THIRD CLASS","FAIL"))))":
 
J

Jacob Skaria

=IF(J13="PASS",IF(I13>=60,"FIRST CLASS",IF(I13>=50,"SECOND
CLASS",IF(I13>=35,"THIRD CLASS"))),"FAIL")

If this post helps click Yes
 
J

Jacob Skaria

I would suggest to use the below formula since it is based on only one
condition ie marks..

=LOOKUP(I13,{0,35,50,60},{"FAIL","THIRD CLASS","SECOND CLASS","FIRST CLASS"})

If this post helps click Yes
 
T

T. Valko

You don't have a value_if_false argument defined for when J13 does not rqual
PASS. That's the only condition that will return FALSE.
 
Top