If Statement

[Trish Smith]

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

 

[T. Valko]

Try this:

=IF(AND(A1="A",OR(E1<>"A",F1<>"A"),OR(G1="A",H1="A")),"A","")

 

[Tom Hutchins]

Try this in I1:

=IF(AND(A1="A",OR(E1<>"A",F1<>"A"),OR(G1="A",H1="A")),"A","")

Hope this helps,

Hutch

 

[David Biddulph]

=IF(AND(A1="A",OR(E1<>"A",F1<>"A"),OR(G1="A",H1="A")),"A","whatever you want
if the conditions aren't met")

 

[Trish Smith]

Thank you Tom,

That's great!
--
Trish

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]

Thank you David,

Looks easy when you do it!

 

[David Biddulph]

It's always easy when you know how! Glad it helped.