Not sure about this but try
=IF(OR(C1="F",E7="F",M7="F"),"F","P")
Regards,
Alan.
"Sue" wrote in message
...
I have a number of spreadsheets that I am creating. I need to generate
results from data in non-sequential cells. Each cell has 3 choices that a
user can select from and the final result would be Pass, Fail or
Incomplete
based on the selections in the other cells. (example: C1=P, E7=F, M7=I
this
would result in I as the end result. C1=P, E7=P, M7=F, this would result
in
F as the final result. I need to be able to create a formulat that would
cover many combinations to get my end result. Each informational cell
has
the values of P, F or I

Any help on this will be very helpful.