a fomula for an entire column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a formula for an entire column, not by inserting a
formula on each cell of that column (I've heard that it is possible, but I
couldn't find a clue on how it's done).
For example, I have 2 columns: column A and column B. I want to set up
a formula for the entire column B, that will divide any number that is
entered in one of the column A cells by 10000.
Hope I've made myself clear enough and that someone could help me on
this.

Thank you in advance
 
Johnny,
in B1 put this formula =A1/10000 > OK

Now double click on the little black square at the bottom right hand
corner of cell B1, or click and drag it down as far as you need to go.

If you have empty cells in column A you might like to change the
formula to

=IF(A1="","no data in column A",A1/10000)

HTH.
 
You must log in or register to reply here.

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

Help needed 0
I can only delete an entire row not a cell in excel 2013? 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel VBA 1
select a range in a column 4
counting blank cells within two columns 2
How do I make a formula work for all the cells in a column? 4
Setting formulas for entire columns ... 1

Back
Top