Result displays "FALSE" instead of "FAIL"

[Formula error]

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

 

[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

 

[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. 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.

 

[FARAZ QURESHI]

Make sure J13 consists of exactly:
PASS
and not a space.