Leaving Cell Blank

  • Thread starter Thread starter Ron A.
  • Start date Start date
R

Ron A.

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
 
=if(d7="","",(G7-D7+(G7<D7))*24)



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
Click to expand...
 
Back
Top