Nested if help

DUSTWUN

New member
Joined
May 17, 2019
Messages
8
Reaction score
0
Points
0
Excel Version(s)
2019
I have a tracker that keeps up with people's tasks.

A1= date task is completed in YYYYMMDD
A2=adds 365 days to show next due date
A3=shows 90/60/30/0 days based on A4
A4=shows how many days left until it's due and when it hits 0(zero) it shows "OVERDUE"

I have successfully used the formula. A4=IF((A3-NOW())<0,"OVERDUE",A3-NOW()) to show days left and OVERDUE

My goal is when I initiated a task, I will enter, "INIT" in A1 and A4 will show "OVERDUE". A4=IF(A1="INIT","OVERDUE",0)

Asking for assistance to have both IF statements in one cell.

1234
A20190101201912310OVERDUE
BINITOVERDUE


Thank you for your help!

-Michael
 
Try this:

=IF(A3="INIT","OVERDUE",IF((A3-NOW())<0,"OVERDUE",A3-NOW()))
 
PERFECT!!! I had to tweak a cell location, but it's exactly what I needed and I just realized I had my table example reversed.

Thanks for your help Ali!



Try this:

=IF(A3="INIT","OVERDUE",IF((A3-NOW())<0,"OVERDUE",A3-NOW()))
 
Back
Top