when first column of formula is blank

[Kelli Webb]

Hi, in the attached column F should be a calculation of the remaining hours to make up a standard 8hr day or to remain blank until something is entered into the fields in columns C D or E.

My formula
appears to be working, except for when columns C and D are blank.

=IF(C3="","",SUM(8-C3,-D3,-E3))

 

[Hui]

F3: either
=IF(LEFT([@Day],1)="S","",8-C3-D3-E3)
or
=IF(WEEKDAY([@Date],2)>5,"",8-C3-D3-E3)

 

[GraH - Guido]

or change the first part of the IF-statement
=IF(SUM(Table1[@[Regular Hours]:[Leave]])=0,"",SUM(8-C3,-D3,-E3))

 

[Peter Bartholomew]

If you are going to go with structured references, why not stick to it throughout?
= IF( SUM(Table1[@[Regular Hours]:[Leave]]),
8 - SUM(Table1[@[Regular Hours]:[Leave]]), "" )

 

[Kelli Webb]

Excellent, thank you to All - I don't know where I would be without you.

Have a great weekend!