G
Guest
How do you formula a cell that will show the result (Pass or Fail) according
the information given from the other cells?
For example, on the column D will have a result of “Fail†if we have “a†or
“x†on the column A, B and C; and result of “Pass†if we have only “bâ€, “câ€
or “e†on the column A, B and C.
A B C D
Level Level Level Pass/Fail
a a c Fail
b x a Fail
c b c Pass
b b x Fail
a a x Fail
b b e Pass
b b b Pass
Thank you for your help.
the information given from the other cells?
For example, on the column D will have a result of “Fail†if we have “a†or
“x†on the column A, B and C; and result of “Pass†if we have only “bâ€, “câ€
or “e†on the column A, B and C.
A B C D
Level Level Level Pass/Fail
a a c Fail
b x a Fail
c b c Pass
b b x Fail
a a x Fail
b b e Pass
b b b Pass
Thank you for your help.