If Statement
Try this in I1:
=IF(AND(A1="A",OR(E1<"A",F1<"A"),OR(G1="A",H1="A ")),"A","")
Hope this helps,
Hutch
"Trish Smith" wrote:
Hi everyone,
Could anyone help me with this one please.
I would like I1 to have a letter A if the following is true;
A1 =A
and
E1 and/or F1 does not = A
and
G1 or H1 = A
Wold it be easier to have helper columns and do it in stages or can it be
done in one go?
Many thanks
--
Trish
|