Not sure about this but try
=IF(OR(C1="F",E7="F",M7="F"),"F","P")
Regards,
Alan.
"Sue" <Sue@discussions.microsoft.com> wrote in message
news:83877597-E1AE-437A-811C-34EF2F39727C@microsoft.com...
>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.
>