View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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