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...
It could be
=IF( ($D10>TODAY())+ISBLANK($D10),"Not Started",IF($F10>100,"Completed",IF($E10>TODAY(),"Overdue","In Progress")))
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")))