View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Leaving Cell Blank

=if(d7="","",(G7-D7+(G7<D7))*24)




Ron A. wrote:

How can this be modified to leave the cell that contains the following
expression blank if D7 is blank? Currently, if D7 is blank then "0" is
returned.

= (G7-D7+(G7<D7) )*24
--
Thanks,
Ron


--

Dave Peterson