Result displays "FALSE" instead of "FAIL"
 

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

Result displays "FALSE" instead of "FAIL"
 

=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


"Formula error" wrote:

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

Result displays "FALSE" instead of "FAIL"
 

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
---------------
Jacob Skaria


"Formula error" wrote:

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

Result displays "FALSE" instead of "FAIL"
 

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.


--
Biff
Microsoft Excel MVP


"Formula error" <Formula wrote in message
...
=IF(J13="PASS",IF(I13=60,"FIRST CLASS",IF(I13=50,"SECOND
CLASS",IF(I13=35,"THIRD CLASS","FAIL"))))":

Result displays "FALSE" instead of "FAIL"
 

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

"Formula error" wrote:

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