IF validation for time totaling

[JSmitty]

Hi, I want to have a validation on a time sheet that if the lunch tim
is not entered then the daily total will not calculate.
The lunch time is entered in cell D15, the daily total is in cell D16.
need an IF validation that states if D15 is 0 then D16 will not tota
and be 0. D16 currently has a formula to add the times from the entir
day together.
Just can't figure this one out, any ideas? Thank yo

 

[Claus Busch]

Hi,

Am Fri, 21 Dec 2012 17:17:32 +0000 schrieb JSmitty:

The lunch time is entered in cell D15, the daily total is in cell D16. I
need an IF validation that states if D15 is 0 then D16 will not total
and be 0. D16 currently has a formula to add the times from the entire
day together.

try:
=IF(D15=0,0,Your Formula)


Regards
Claus Busch

 

[Spencer101]

Hi, I want to have a validation on a time sheet that if the lunch tim
is not entered then the daily total will not calculate
The lunch time is entered in cell D15, the daily total is in cell D16.
need an IF validation that states if D15 is 0 then D16 will not tota
and be 0. D16 currently has a formula to add the times from the entir
day together
Just can't figure this one out, any ideas? Thank yo

Hi

=IF(D15="",0,-*InsertYourForumlaHere*-