Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Johnny
 
Posts: n/a
Default a fomula for an entire column

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
  #2   Report Post  
greg7468
 
Posts: n/a
Default


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.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=384810

  #3   Report Post  
Anne Troy
 
Posts: n/a
Default

This is so quickly done by the fill handle:
http://www.officearticles.com/excel/...soft_excel.htm

Or do you need a macro?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"Johnny" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
how do I change case in an entire column of text in Excel linpengie Excel Worksheet Functions 9 April 1st 05 12:32 AM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 07:19 PM
How to add the same value to an entire column? Brita Excel Discussion (Misc queries) 2 December 22nd 04 01:55 AM
How can I sort an entire spreadsheet from a list prod sorter Excel Worksheet Functions 4 November 17th 04 04:43 AM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"