Solved Help with an IF statement using dates

June 26, 2014 at 08:23:14
Specs: Windows 7
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.

See More: Help with an IF statement using dates

Report •

June 26, 2014 at 11:17:39
✔ Best Answer
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.

Report •
Related Solutions

Ask Question