If all cells equals a value then format a cell

[Post2gary]

Please can you help?

I have a column that contains 3 different value, "P", "F" and "N" - (Pass, Fail and Not Started)

If ALL cells in the column = "P" then I want a cell underneath to say "Pass"

If ANY of the cells in the column contain "F" then I want a cell underneath to say "Fail"

If any cells in the column = "N" then I want the cell underneath to say "Not Started"

I've searched everywhere but can't find the answer - please help, I'm wearing my function out!!

Thanks

[teylyn]

Hello,

if the values are in cells A1 to A20, then try this formula

=IF(COUNTIF(A1:A20,"p")=ROWS(A1:A20),"pass",IF(COUNTIF(A1:A20,"n"),"not started ",IF(COUNTIF(A1:A20,"f"),"fail","not all values entered")))

cheers,