I have the following logic for which I have been valiantly attempting an IF statement for. As I have been unsuccessful – I am here.
Cell AN3 has a value of “On-going” or “Completed”
IF AN3=“On-going” then:
“On time” If P3>7/31/16
“In the month” If P37/1/16
“Overdue” If P3<7/1/16
"No due date" If P3="" (blank)
IF AN3="Completed" then"
"On time request" IF AM3<=0 ([/B]
“No due date” If P3=”” (blank)
I’m not sure my failed attempts will be of any use, but my most recent attempt was:
=IF(AN3=”On-going”,IF(P3=””,”No Due Date”,IF(P3″7/31/16)”,”On Time”,”Due in the Month”))),IF(P3=””,”No Due Date”,IF(AM3>0,”Late Request”,”On Time Request”)))
There seems to be 1 scenario to slip through the cracks no matter which way I turn.
Thanks in advance for the assistance.
-Jody
