Look in HELP for the AND() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"joanie23" wrote in message ...
|I want to compare two quarter grades to see if a student improved, stayed the
| same or decreased. the first quarter is cell b3 and the second quarter is
| cell b8.
|
| if the first quarter is "s", and the second quarter is either "u" or "i"
| then the student decreaed. If the first quarter is "u" and the second quarter
| is "s" or "i" then the student improved. If the first quarter is "i" and the
| second quarter is "s" then the student improved. If the first quarter is "i"
| and the second quarter is "u" then the student decreased.
|
| My if statement isn't working properly - see below. Any suggestions? thanks.
|
| =IF(B3=B8,"same",IF(B3="s"&B8<"s","declined", IF(B3="u"&B8<"u",
| "improved", IF(B3="i"&B8="s", "improved","down"))))
|
|