Adding two if Statements together

S

sharonking66

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.
 
R

Roger Govier

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")))
 
G

Greg Wilson

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
 
D

David Biddulph

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?
 
G

Greg Wilson

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.
Click to expand...
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
 
Top