IF AND OR combo

[odonovanc]

I just cannot seem to get this right today. I'm trying this:

=IF(AND(E4=0,D4>0)*OR(C4>D2),"New",IF(AND(E4>500,D4>500),"Mature","Winding Down"))

Not giving me what I want. I want if E4=0 and D4>0 or if C4>D2 to give me "New". If E4>500 and D4> 500 give me "Mature" otherwise "winding down". Can someone debug my formula. Thanks.,

No matter what I put in C4 it is not impacting my response. If it matters, C4 and D2 are dates.

 

[jtakw]

Hi,

Based on your written description, try:

=IF(OR(AND(E4=0,D4>0),C4>D2),"New",IF(AND(E4>500,D4>500),"Mature","Winding Down"))

 

[odonovanc]

Got it. Thanks.

 

[jtakw]

You're welcome.