Show Blank Instead Of "0"

[RandyD123]

If I have nothing in my E or F column, the cells in G show a "0", where the formula below is. How can I correct this so the cells in G show blank if nothing is in E or F?

=(TEXT(F4,"00\:00")-TEXT(E4,"00\:00"))*24


The same thing with the formula below. D2 is a static number (20%). If I have nothing in some of the cells in the C column, how can I get the result in D to be blank instead of showing "0"?

=SUM(C4 * 6.5)*($D$2)

Thanks for any help.

 

[AlanY]

try
=if(CELL=0,"",SUM(C4 * 6.5)*($D$2))
similar for the other

 

[Fluff]

How about

=IF(AND(E4="",F4=""),"",(TEXT(F4,"00\:00")-TEXT(E4,"00\:00"))*24)

and

=IF(C4="","",C4*6.5*$D$2)

 

[RandyD123]

try
=if(CELL=0,"",SUM(C4 * 6.5)*($D$2))
similar for the other

try
=if(CELL=0,"",SUM(C4 * 6.5)*($D$2))
similar for the other

I get a #NAME? error

 

[AlanY]

Cell is the cell address as shown on post #3

or you can do this

Display or hide zero values - Microsoft Support

Hide or display zero values in Excel worksheets by using an option in the Advanced tab, or by using a number format, using a conditional format, a function, and by hiding zeros in PivotTable reports.

support.microsoft.com

 

[RandyD123]

How about

=IF(AND(E4="",F4=""),"",(TEXT(F4,"00\:00")-TEXT(E4,"00\:00"))*24)

and

=IF(C4="","",C4*6.5*$D$2)

Yes, both work perfectly. Thank You!

 

[AlanY]

glad that work for you

 

[Fluff]

Glad we could help & thanks for the feedback.