My basic IF statement is IF J6>110% and IF L6<-5000, return "REVISION NEEDED" otherwise "OK". I've got this part using this: =IF(AND(J6>110%,L6<-5000),"REVISION NEEDED","OK") The tricky part is that I need to add that IF C6=>9/1/2013, the previous formula should compare 110%. IF C6<9/1/2013, the previous formula should compare 115%.

Any help would be appreciated. Thanks in advance.

I'm pretty sure this gets you what you want... Since everything seems to be dependent on the value in L6, I pulled that out separately. In other words, IF L6>=-5000, we don't care about anything else, because we're "OK".

Once we know that L6 is <-5000, we can check the date and percentage. If either of the 2 AND conditions are FALSE, then all we care about is whether or not J6 is >110%.

Try this:

=IF(L6>=-5000,"OK",IF(AND(C6<DATEVALUE("9/1/2013"),J6>115%),"Revision Needed",IF(J6>110%,"Revision Needed","OK")))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll