IF Function for three conditions? How? PLEASE.

[jpbonono]

Badly needed your help here masters!

You will notice the "remarks" field (cell E, H, K, N, Q, T, W, Z) with a total count of 8. I have three conditions for the "final remark" (cell AC) and these are:

1. if FAILED remark counted less than equal to "7" (seven) but not "0" (zero), FINAL REMARK should be "IRREGULAR".
2. if FAILED remark counted "0" (zero), FINAL REMARK should be "RETAINED".
3. if PROMOTED remark counted "8" (eight) or no FAILED remark is acquired, FINAL REMARK should be "REGULAR"

Here's the screen shot.

Your ASAP help will be very much appreciated.

Thanks guys!

 

[jpbonono]

Thanks guys. This is what im looking for.

=IF(COUNTIF(E6:Z6,"FAILED")=8,"RETAINED",IF(COUNTIF(E6:Z6,"FAILED")=0,"REGULAR","IRREGULAR"))