IF validation for time totaling
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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|