IF Function with Multiple Criteria

[ltmaiyk]

I have this table:

Math Science Language Overall
Pass Pass Pass ----
Pass Fail Pass ----
Pass Fail Fail ----
Fail Fail Fail ----

What formula should I use to show "Pass" if a student passed all three subjects, "FAIL" If student did not pass in any subject and "TRY AGAIN" if he passed at least one subject?

I can't seem to accurately plot "IF" formula. Should add in "AND" / "OR" as well?

Thanks in advance!

[NBVC]

=Choose(Countif(B2:D2,"Pass")+1,"Fail","Try Again","Try Again","Pass")

where B2:D2 contain the scores...

copied down.

[boatbabe]

Hi there, I would creat columns next to the results with numbers that corealate to the Pass or Fail, I used 1 for Pass and 0 for Fail with this formula =IF(A8="Pass",1,0). If you think that you may have something else in there instead of Fail you should specify to only return 0 for Fail, otherwise it may skew your results.
You can then use a nested If for the calculation ie =IF(B8+D8+F8>=3,"Pass",IF(B8+D8+F8=0,"Fail","Try Again"))
Once it's working you can hide the numbers columns.
My sheet looks like this:
Math Science Language Overall
Pass 1 Pass 1 Pass 1 Pass
Pass 1 Fail 0 Pass 1 Try Again
Pass 1 Fail 0 Fail 0 Try Again
Fail 0 Fail 0 Fail 0 Fail
It's not particularly elegant but it works!
HTH
Nina

[ltmaiyk]

Thanks for the prompt response. The answers you gave will work if I included another column that shows numeric values. As for this problem, no numeric value should be added. Does that even make any sense?

[NBVC]

The formula I submitted does not require other columns... it counts the number of "Passes" and determines the result based on that count..

[ltmaiyk]

you're right. thanks much