Leaving Cell Blank

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
 
D

Dave Peterson

=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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

returning blank cell when conditions not met 4
Calculating Time 5
How do I assign "Apple" to a cell reference in this evaluate code? 2
Formula - If Statement with blank 3
Diplaying results of a formula instead of the formula itself 1
Rounding in the Same Cell 2
copying a cell that has been formatted to cell with conditionals 1
Help with date formula 2

Top