Forum Discussion

Edg38426's avatar
Edg38426
Brass Contributor
Nov 18, 2021
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...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Nov 18, 2021

    Edg38426 

    How about

     

    =IF(L2="","",L2-IF(C2="Spec",I2,F2))

HansVogelaar's avatar
HansVogelaar
MVP
Nov 18, 2021

Edg38426 

How about

 

=IF(L2="","",L2-IF(C2="Spec",I2,F2))

  • Edg38426's avatar
    Edg38426
    Brass Contributor
    Nov 18, 2021
    This worked quite well, thank you. I guess I should have avoided the DAYS formula altogether, eh?
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 18, 2021

      Edg38426 

      This would work as well:

       

      =IF(L2="","",DAYS(L2,IF(C2="Spec",I2,F2)))

      • Edg38426's avatar
        Edg38426
        Brass Contributor
        Nov 18, 2021
        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)

Resources