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...
SergeiBaklan thank you! It solved my "Not Started" issue but wiped out my "Overdue" rule.
It all seems to work if I combine your solution with mine
=IF( ($D4>TODAY())+ISBLANK($D4),"Not Started",IF(NOT(ISBLANK(F4)),"Complete",IF(AND(F4="",E4<TODAY()),"Overdue","In Progress")))
