IF(AND Statements

[JRose0303]

I have input the following IF(AND statement, =IF(AND(H4<G2,J4=0),"Past Due"," "); however, I cannot seem to get the cell to remain blank when H3 has not been populated (it stays Past Due).

H4 = a date field to be populated as an end date of an authorization

G2 = Today's Date

J4 = a date field to be populated as a authorization extension date

I4 = formulated cell - This cell I want to remain blank when H3 has not been populated and to only populate as "Past Due" when H3 is less than today's date (G2) and J3 has not been populated; otherwise, stay blank (" ").

When H4 is populated, everything works fine; it's when there's nothing there that I'm running into the issue.

I've attached a picture view of what I'm working on as a visual.

Excel Forum Pic.JPG

Thank you so much for your help with this!

[Thalassa]

Try

=IF(AND(H4<>"",H4<G2,J4=0),"Past Due","")

[JRose0303]

Oh my gosh!! It worked! Thank you so much! I have been working on this on and off for a couple weeks. I would play with it, get frustrated because I couldn't figure out what I was doing wrong, and not touch it for another week. LOL! Thank you so so much!!!!

[JRose0303]

If I wanted the formulated cell to populate with "Past Due" 4 days prior to G2 (Today's Date), how would I put that?

[FDibbins]

try

=IF(AND(H4<>"",H4<G2-4,J4=0),"Past Due","")

[JRose0303]

I figured out what I needed to do. I wound up having to use nested if/and statements:

=IF(AND(L2<>"",K1=L2-4,O2=0),"REQ EXT",IF(AND(L2<>"",K1=L2-3,O2=0),"REQ EXT",IF(AND(L2<>"",K1=L2-2,O2=0),"REQ EXT",IF(AND(L2<>"",K1=L2-1,O2=0),"REQ EXT"," "))))

Thank you guys so much for all of your help!!