Forum Discussion
Excel Formula with multiple IF conditions
Need help on the below to combine multiple conditions.
| i5<g5 | Completed on track |
| i5>g5 | Completed delayed |
| i5=blank | WIP Ontrack |
g5<today + i5=blank | WIP delayed |
managed to get till the 3rd criteria, but the last one has both 3rd & 4th combined, which is not picking up.
=IF(ISBLANK(I5),"WIP-OnTrack",IF(I5<=G5,"Completed-OnTrack",IF(I5>G5,"Completed-Delayed",IF(OR(I5="",G5<TODAY()),"WIP-Delayed",""))))
Please help
Use
=IF(I5="", IF(G5<TODAY(), "WIP Delayed", "WIP On Track"), IF(I5<=G5, "Completed On Track", "Completed Delayed"))
5 Replies
Use
=IF(I5="", IF(G5<TODAY(), "WIP Delayed", "WIP On Track"), IF(I5<=G5, "Completed On Track", "Completed Delayed"))
Need one more favor, by adding an additional condition to the expression you shared.
that is, if G5 > i5, 'Completed Ahead Time'. This is to check if the task was completed much ahead the Planned task date. We have added Completed OnTrack, which could be marked if g5=i5.
=IF(I5="", IF(G5<TODAY(), "WIP Delayed", "WIP On Track"), IF(I5<=G5, "Completed On Track", "Completed Delayed"))
That would be
=IF(I5="", IF(G5<TODAY(), "WIP Delayed", "WIP On Track"), IF(I5<G5, "Completed Ahead Of Time", IF(I5=G5, "Completed On Track", "Completed Delayed")))
If you have Excel 2019 or Excel in Microsoft 365, you can also use
=IF(I5="", IF(G5<TODAY(), "WIP Delayed", "WIP On Track"), IFS(I5<G5, "Completed Ahead Of Time", I5=G5, "Completed On Track", I5>G5, "Completed Delayed"))
- Thank you so much. Didn't realize that it was such a easy code, and i went around the world 🙂
Thank you once again.
