Forum Discussion

Mps1979

Copper Contributor

Jul 11, 2021

Solved

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 ...

Formulas and Functions

HansVogelaar
Jul 11, 2021
Mps1979

Use

=IF(I5="", IF(G5<TODAY(), "WIP Delayed", "WIP On Track"), IF(I5<=G5, "Completed On Track", "Completed Delayed"))

Mps1979

Copper Contributor

Jul 11, 2021

HansVogelaar

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"))

HansVogelaar

MVP

Jul 11, 2021

Mps1979

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"))

Mps1979
Copper Contributor
Jul 11, 2021
it worked well. Thank you so much