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.