Adding two if Statements 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.
|