Forum Discussion
Solved
Calculating cycle time based on different criteria
I am trying to use DAYS to calculate cycle time based on Job Type, which would be simple enough, but I'd like to use the IF(L2="","",....) to leave the cell blank if the cycle is not complete. If the...
This worked quite well, thank you. I guess I should have avoided the DAYS formula altogether, eh?
- So what I'm seeing is that my issue was that I was trying to use two different job types in the formula, where I should have just been using one (if "Spec" then X, otherwise Y)
Yes, assuming that the job type will always be either Spec or Build.
On the other hand, it would be possible to do it like this:
=IF(L2="","",L2-IFS(C2="Spec",I2,C2="Build",F2))