Help with IF / Then Subtraction
For our Project Management team, we calculate the total duration or 'Cycle Time' of our projects which is working well. However, sometimes, projects are on hold for a number of days. I would like to create a formula that subtracts the number of days a project is On Hold( "On Hold Duration" Column) from the Total Cycle time, ("Cycle Time" Column). My challenge is, how do I write a formula that will perform the subtraction only when there is a On Hold Duration Value, and when blank, just results the same number in the "Cycle Time Column"?
The formula I currently have in the "Cycle Time With On Hold" Column is the following. It only works when there is a value in the "On Hold Duration". I assume I need to use an IF THEN type statement?
=IFERROR([Cycle Time]@row - [On Hold Duration]@row, "")
Any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!