View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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
---