ExcelBanter - Leaving Cell Blank

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Leaving Cell Blank (https://www.excelbanter.com/excel-worksheet-functions/244630-leaving-cell-blank.html)

Ron A.[_2_]

Leaving Cell Blank

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

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

Ron A.[_2_]

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

All times are GMT +1. The time now is 08:47 PM.