If Statement
 

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

If Statement
 

Try this:

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

--
Biff
Microsoft Excel MVP


"Trish Smith" wrote in message
...
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

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

If Statement
 

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

"Trish Smith" wrote in message
...
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

If Statement
 

Thank you Tom,

That's great!
--
Trish


"Tom Hutchins" wrote:

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

If Statement
 

Thank you David,

Looks easy when you do it!
--
Trish


"David Biddulph" wrote:

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

"Trish Smith" wrote in message
...
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

If Statement
 

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

"Trish Smith" wrote in message
...
Thank you David,

Looks easy when you do it!
--
Trish


"David Biddulph" wrote:

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

"Trish Smith" wrote in message
...
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