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.
> >> >
> >>
> >>
> >>
>
>
>