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.