Forum Discussion

DominiqueKohoron's avatar
DominiqueKohoron
Copper Contributor
May 15, 2023
Solved

Formula for SUM if Not Blank and Display 3 If Less Than 3

Hi,   I am trying to set up a timesheet spread sheet that will sum if the cells aren't blank and return the answer as a minimum of 3. For the rows that are blank, I still want it to show 0.    Th...
  • OliverScheurich's avatar
    OliverScheurich
    May 15, 2023

    DominiqueKohoron 

    =IF(C14="",0,MAX(3,SUM(D14-C14-E14)*24))

    Does this return the intended result? 

Resources