Combination of IF, AND, and COUNTIF; need help
To satisfy this
If there are any Fs give me an overall F.
If there are any NTs ignore them.
If ALL are Ps give me an overall of P.
One way:
=IF(COUNTIF(H8:H10,"F")0,"F",IF(COUNTIF(H8:H10,"P ")=3,"P",""))
Test it out, hit YES below for a thumbs up
The "=3" bit in the check for "P" is the number of cells in the range H8:H10
Note that you can sequence the IF checks to suit as it will be evaluated
from left to right
--
Max
Singapore
---
|