Hi!

Try this:

=IF(OR(C1="",E7="",M7=""),"",IF(OR(C1="I",E7="I",M7="I"),"I",IF(OR(C1="F",E7="F",M7="F"),"F","P")))

Biff

"Sue" <Sue@discussions.microsoft.com> wrote in message
news:8E714AF5-BD5B-4E99-B0DF-858B8EBFFCE3@microsoft.com...
> Alan,
>
> Thx for responding. Pass criteria is all three cells c1, e7, m7 all have
> P
> (Pass) as their result. I could have P, I, F, or I, I, F, or P, P, F, or
> P,
> P, I, or F, F, F or I, I, I. and I could probably go on. The Pass is the
> easy one. C1, E7 and M7 all P = a final result of P. Any combination
> with
> an I constitutes a final result of I and all F's is a failure
>
> Regards,
> Sue
>
> "Alan" wrote:
>
>> Sue,
>> What's the pass criteria? Do you mean if any one category is an 'F' then
>> that constitutes an overall failure? Do doubt in can be done but need
>> more
>> detail,
>> Regards,
>> Alan.
>> "Sue" <Sue @discussions.microsoft.com> wrote in message
>> news:F906DCA2-A838-453D-850B-50AACF25E029@microsoft.com...
>> > Alan,
>> >
>> > Thanks. This helps somewhat. However, do you know of a way to show c1
>> > with
>> > all it's possible select choices, e7 with it's choices and m7 with it's
>> > choices with the (equally any number of combinations) with the end
>> > results
>> > being F, P or I. I'm probably confusing things here. C1 has P, F or I
>> > as
>> > selection choices, as does e7 and m7.. My final result will be based
>> > on
>> > any
>> > combination of the three. I've been wracking my brain on this all day.
>> > It
>> > may well be that I have to put each combination of arrays into a
>> > separate
>> > cell rather than in a single cell.
>> >
>> > Regards, Sue
>> >
>> > "Alan" wrote:
>> >
>> >> 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.
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>