"Yes" or "No" Nested IF Statement with Specified Date

[QBERT]

Here is what I am trying to do:

=IF(AA5="","No",IF(AA5<=J5,"Yes","No")) - My lame attempt

Upload Days = AA5 (The number of days to acutally complete the project)
SLA Days = J5 (The number of days allowed to complete a project)
Project Uploaded Date = M5 (The date that the project was completed)
Report Date = B1 (The date of the report)
SLA Met = AC5 (The cell that I need an Equation that will display "Yes" or "No"

What I want is an IF Statement in cell AC5 that will:

- Display a blank cell if there is no data in AA5 (This means the project is in progress)
- Display a "Yes" or a "No" for the project if the Project Uploaded Report Date (M5) is equal to or earlier than the Report Date (B1)
- It should display "Yes" if the Upload Days - SLA Days is equal to or less than zero.
- It should display "No" if the Upload Days - SLA Days is greater than zero.

Thanks!

Update: If there is a "cute" way to have the report date always be today's date that will work too. I am trying to avoid as much manual typing as possible. Thanks!

Q

 

[QBERT]

I am trying this right now and it looks good. Any confirmation?

=IF(AND(M5<=TODAY(),AB5<=0),"Yes",IF(AND(M5>TODAY(),AB5>0),"","No"))

I still don't know how to incorporate a "Blank" check at the beginning that states "IF M5 is Blank" return a value of Blank; not "Yes" or "No".

 

[QBERT]

=IF(M14="","",IF(AND(M14<=TODAY(),AB14<=0),"Yes",IF(AND(M14>TODAY(),M14<=TODAY(),AB14>0),"","No")))

Trying this now...not working exactly. The last half of the equation is tripping me up. I think the last logical argument needs to be broken up.

M14 = Upload Date
AB14 = SLA (Defined as the Upload Days - SLA Days)

 

[MarcelBeug]

This is what I had in mind (unaware of your previous posts):

=IF(AA5="","",IF(M5<=B1,IF(J5>=AA5,"Yes", "No"),[I]Value if Project Uploaded Date > Report Date[/I]))

B1 can be replaced with TODAY()
You'll need to determine what happens if PUD > RD

 

[QBERT]

=IF(M14="","",IF(AND(M14<=TODAY(),AB14<=0),"Yes",IF(AND(M14<=TODAY(),AB14>0),"No",IF(M14>TODAY(),"","FALSE"))))

I ran out of arguments and used "False" at the End. Seems to be working and I am testing now.

 

[MarcelBeug]

No need to supply a FALSE argument with an IF function. If you do: don't put it in double quotes.

In other words: =IF(A1 < B1,"A1 is smaller than B1") is equivalent to =IF(A1 < B1,"A1 is smaller than B1",FALSE)

 

[MarcelBeug]

I ran out of arguments

Excel allows 64 nested IFs since Excel 2007... Not recommended though.

Otherwise my advice would be not to use AND in this case.

 

[MarcelBeug]

Shortened version of your formula in post #5, if you want FALSE (if M14 > 0) and not "FALSE"

=IF(M14="","",IF(M14<=TODAY(),IF(AB14<=0,"Yes","No")))