Hiding a zero Value plus 0.2

[Guest]

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

 

[Niek Otten]

Hi Miles,

=IF(C18="","",CELL("contents",C18)*24+0.2)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Bill Kuunders]

=IF(C18="","",IF(C18=0,"",C18*24+0.2))

the cell will stay blank if c18 is a zero or blank

Any reason why you use CELL("contents")????

Regards

Bill K

 

[mcr1]

Nick, thanks for your help, but I am still getting the same 0.2. An
other suggestions

 

[Frank Kabel]

Hi
see your other post

 

[mcr1]

Bill, thanks. It works like a champ. I use cell contents because I a
referencing the cell, but I am still learing so I think I have found
better way now with your help. Thanks a million.

Mile