Hiding Zero Value plus 0.2

[mcr1]

I am using this formula, =CELL("contents",C18)*24+0.2, and in the blank
cell it puts 0.2 Is there anyway that the cell can be left blank until
I enter data into the referenced (c18) cell? Thanks in advance for your
help.

Miles Reed

 

[Frank Kabel]

Hi
use
=IF(C18="","",C18*24+0.2)