Hiding Zero Value plus 0.2

  • Thread starter Thread starter mcr1
  • Start date Start date
M

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
 

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

Hiding a zero Value plus 0.2 5
Hide a formula result until cell has been filled 16
Getting Info from Last cell used 1
Omit empty cells? 0
Sheet Value in Cell? Is this possible 4
Cell value not recognize in an expression 3
Can anyone see a problem with this? 13
duplicating excel formulas 1

Back
Top