If I have two if statement, how do I make it one. For example, I want
to add:

=IF(AND(W2="Open",OR(AE2="CMRA",AE2="MRC-PARTS",AE2="IN-
DIRECT",AE2="DOA",AE2="MRC-PARTS/LABOUR",AE2="REPAIR"),(TODAY()-
D2)=8),"yes","no")

and

=IF(AND(W2="Open",OR(AE2="DIRECT",AE2="IN-DIRECT CONFIG",AE2="DIRECT
TOUCH",AE2="HOSTED"),(TODAY()-D2)=22),"yes","no")

together.

Hi

Try
=IF(W2<"open","no",
IF(AND(OR
(AE2="CMRA",AE2="MRC-PARTS",AE2="IN-DIRECT",AE2="DOA",
AE2="MRC-PARTS/LABOUR",AE2="REPAIR"),
TODAY()-D2=8),"yes",
IF(AND(OR
(AE2="DIRECT",AE2="IN-DIRECT CONFIG",AE2="DIRECT TOUCH",
AE2="HOSTED"),TODAY()-D2=22),"yes","no")))

--
Regards

Roger Govier


wrote in message
ups.com...
If I have two if statement, how do I make it one. For example, I want
to add:

=IF(AND(W2="Open",OR(AE2="CMRA",AE2="MRC-PARTS",AE2="IN-
DIRECT",AE2="DOA",AE2="MRC-PARTS/LABOUR",AE2="REPAIR"),(TODAY()-
D2)=8),"yes","no")

and

=IF(AND(W2="Open",OR(AE2="DIRECT",AE2="IN-DIRECT CONFIG",AE2="DIRECT
TOUCH",AE2="HOSTED"),(TODAY()-D2)=22),"yes","no")

together.

My interpretation was that you only need the condition <<< Today() - D2 =8
since it is also satisfied when the condition <<< Today() - D2 =22
is met. You may however want to make it the other way around or another
restriction.

=IF(AND(W2 = "Open", NOT(ISERROR(MATCH(AE2,
{"CMRA","MRC-PARTS","IN-DIRECT","DOA","MRC-PARTS/LABOUR","REPAIR","DIRECT","IN-DIRECT
CONFIG","DIRECT TOUCH","HOSTED"}, 0))), TODAY() - D2 =8), "Yes", "No")

Regards,
Greg

" wrote:

If I have two if statement, how do I make it one. For example, I want
to add:

=IF(AND(W2="Open",OR(AE2="CMRA",AE2="MRC-PARTS",AE2="IN-
DIRECT",AE2="DOA",AE2="MRC-PARTS/LABOUR",AE2="REPAIR"),(TODAY()-
D2)=8),"yes","no")

and

=IF(AND(W2="Open",OR(AE2="DIRECT",AE2="IN-DIRECT CONFIG",AE2="DIRECT
TOUCH",AE2="HOSTED"),(TODAY()-D2)=22),"yes","no")

together.

Doesn't the 8 condition apply if AE2 is
"CMRA", "MRC-PARTS", "IN-DIRECT", "DOA", "MRC-PARTS/LABOUR", or "REPAIR",
and the 22 condition if AE is
"DIRECT", "IN-DIRECT CONFIG", "DIRECT TOUCH", or "HOSTED", Greg?
--
David Biddulph

"Greg Wilson" wrote in message
...
My interpretation was that you only need the condition <<< Today() - D2
=8
since it is also satisfied when the condition <<< Today() - D2 =22
is met. You may however want to make it the other way around or another
restriction.

=IF(AND(W2 = "Open", NOT(ISERROR(MATCH(AE2,
{"CMRA","MRC-PARTS","IN-DIRECT","DOA","MRC-PARTS/LABOUR","REPAIR","DIRECT","IN-DIRECT
CONFIG","DIRECT TOUCH","HOSTED"}, 0))), TODAY() - D2 =8), "Yes", "No")

Regards,
Greg

" wrote:

If I have two if statement, how do I make it one. For example, I want
to add:

=IF(AND(W2="Open",OR(AE2="CMRA",AE2="MRC-PARTS",AE2="IN-
DIRECT",AE2="DOA",AE2="MRC-PARTS/LABOUR",AE2="REPAIR"),(TODAY()-
D2)=8),"yes","no")

and

=IF(AND(W2="Open",OR(AE2="DIRECT",AE2="IN-DIRECT CONFIG",AE2="DIRECT
TOUCH",AE2="HOSTED"),(TODAY()-D2)=22),"yes","no")

together.

David,

It's a matter of interpretation and judgement as to what you think the OP
most likely wants. The formulae seem to imply the OP is from the auto service
industry and therefore may not have any experience with Excel, and so may
have difficulty simply blending the two. I don't get the impression the OP is
the author of the formulae.

If the OP wanted an If / ElseIf structure I figured would have said
something about structure. All the OP said was:
If I have two if statement, how do I make it one.
Then says to add formula1 and formula2 together.

The first formula implies if W2 = "Open" and AE2 is equal to one of the
items in the first list and its a week or more old then return "yes" else
return "no". The second implies if W2 = "Open" and AE2 is equal to one of the
items in the second list and it's 3 weeks or more old then return "yes" else
return "no". In the auto service industry, I don't see the relavence of such
an If / ElseIf conditional setup. I was expecting feedback from the OP to
sort it out.

Regards,
Greg


"David Biddulph" wrote:

Doesn't the 8 condition apply if AE2 is
"CMRA", "MRC-PARTS", "IN-DIRECT", "DOA", "MRC-PARTS/LABOUR", or "REPAIR",
and the 22 condition if AE is
"DIRECT", "IN-DIRECT CONFIG", "DIRECT TOUCH", or "HOSTED", Greg?
--
David Biddulph

"Greg Wilson" wrote in message
...
My interpretation was that you only need the condition <<< Today() - D2
=8
since it is also satisfied when the condition <<< Today() - D2 =22
is met. You may however want to make it the other way around or another
restriction.

=IF(AND(W2 = "Open", NOT(ISERROR(MATCH(AE2,
{"CMRA","MRC-PARTS","IN-DIRECT","DOA","MRC-PARTS/LABOUR","REPAIR","DIRECT","IN-DIRECT
CONFIG","DIRECT TOUCH","HOSTED"}, 0))), TODAY() - D2 =8), "Yes", "No")

Regards,
Greg

" wrote:

If I have two if statement, how do I make it one. For example, I want
to add:

=IF(AND(W2="Open",OR(AE2="CMRA",AE2="MRC-PARTS",AE2="IN-
DIRECT",AE2="DOA",AE2="MRC-PARTS/LABOUR",AE2="REPAIR"),(TODAY()-
D2)=8),"yes","no")

and

=IF(AND(W2="Open",OR(AE2="DIRECT",AE2="IN-DIRECT CONFIG",AE2="DIRECT
TOUCH",AE2="HOSTED"),(TODAY()-D2)=22),"yes","no")

together.