Maybe this suffices, test it out:
=IF(OR(H6="F",H14="F",H18="F"),"F",IF(OR(H6="P",H1 4="P",H18="P"),"P",""))
--
Max
Singapore
---
"KL" wrote:
Max you are awesome! I have to ask was I even close to being on the right
track with the formula I had come up with?

Ok so my next, and I believe last question, is how do I ignore if the cell
is blank?

For example:

H1 would use the formula:
=IF(OR(H6="F",H14="F",H18="F"),"F",IF(AND(H6="P",H 14="P",H18="P"),"P",""))

But say H6=P, H14=P, but H18=NT (or blank). Currently the formula gives a
calue of Blank. But I need it to be able to result a P, as the blank would be
ignored.

The same would happen if H6=F, H14=P, and H18=NT (blank). The result would
be H1=F, the blank in H18 would be ignored.

Does that make sense? I do appreciate your help. I am pretty good at
figuring out formulas in excel but I have been at a loss for this one.

Karen :)