Forum Discussion

Mps1979's avatar
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's avatar
    HansVogelaar
    Jul 11, 2021

    Mps1979 

    Use

     

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

HansVogelaar's avatar
HansVogelaar
MVP
Jul 11, 2021

Mps1979 

Use

 

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

Mps1979's avatar
Mps1979
Copper Contributor
Jul 11, 2021
Thank you so much. Didn't realize that it was such a easy code, and i went around the world 🙂
Thank you once again.

Resources