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.