View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron A.[_2_] Ron A.[_2_] is offline
external usenet poster
 
Posts: 4
Default Leaving Cell Blank

Thank you!
--
Ron


"Dave Peterson" wrote:

=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