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...
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))
- Oh, this may work better, actually. There are very rare instances where the Job Type will be "Model" (only once per worksheet). If I use the nested IFS, then I could account for this variant as well! Thank you for your help, Hans.