Forum Discussion
Nesting "IF" with "IF AND" functions with 4 values
In my project management excel sheet, I'd like it to auto-populate whether a task is "Complete", "Overdue", "In Progress", or "Not Started" based on three cells and the dates they do or do not contai...
Try this:
=IF(OR(D10>TODAY(),D10=“”),
“Not Started”,
IF(F10>0,”Completed”,
IF(AND(F10=“”,E10>TODAY()),
“Overdue”,”In Progress”)))
=IF(OR(D10>TODAY(),D10=“”),
“Not Started”,
IF(F10>0,”Completed”,
IF(AND(F10=“”,E10>TODAY()),
“Overdue”,”In Progress”)))