Nov 18 2021 06:41 AM
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 Job Type is "Spec", then I need the formula in M2 to calculate the days calculated between L2 and I2, if "Build", then I need days between L2 and F2.
Again, this wouldn't normally be a problem for me, but as I said I'm trying to get the cell M2 to be blank if L2 is also blank (cycle not yet complete). Is this just not possible without a separate reference cell or something? Can someone help? I've been trying to use IFS and nested IF statements, but I think that perhaps I'm getting my order of logic messed up.
(sample file attached for reference)
Nov 18 2021 06:51 AM
SolutionNov 18 2021 06:58 AM
Nov 18 2021 07:03 AM
Nov 18 2021 07:05 AM
Nov 18 2021 07:07 AM
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))
Nov 18 2021 07:09 AM
Nov 18 2021 06:51 AM
Solution