How do I apply formula to entire column

S

Stephan

When I apply the formula to the entire column (a running total that is
updated everyday) "0" appear in all the ensuing cells that have not yet been
used. I would like to be able to apply the formula to current and future
entries without Exel placing those "0" in the cells not yet used. Does that
make any sense?
Thanks
Stephan
 
C

Carim

Hi Stephan,

If I understand correctly, you just need to encapsulate your formula
into an If() function :

= If(yourformula=0,"",yourformula)

HTH
Cheers
Carim
 

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

Applying formula to an entire column 1
need help in fine-tuning a formula that removes blank cells in a column range 3
Setting formulas for entire columns ... 1
VLookup or Macro? 0
Applying a name to a sheet other than that on which the name is defined 0
How do I make a formula work for all the cells in a column? 4
Applying Formulas to a Range in a Worksheet 4
Formula on a dynamic range of cells 1

Top