 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008how to multiply entire colume?
How to multiply entire colume with constant: For example I have colume A 21 26 28 33 77 I wish to multiple all of colume A with 7 and put product result in colume B 21 147 26 182 28 196 33 231 77 539 how do I insert single formula vulue in colume B at one time during edit? (by selecting all the cells in colume B)? Thank you. You can do it in place by entering 7 in an unused cell. Copy that cell. Select the range in column A and, in place, Edit>Paste Special>Multiply>OK>Esc If you want to keep column A just copy it to column B then do the above on column B OR enter 7 in C1 In B1 enter =A1*C1 then double-click on the fill handle of B1 and it will copy down. Gord Dibben MS Excel MVP >How to multiply entire colume with constant: > [quoted text clipped - 18 lines] > >Thank you. Say your numbers start in A1. In B1, enter this formula: =A1*7 Click back in B1 to select it. Hover your cursor over the lower right corner of B1, where you see a tiny black square. When the cursor changes from a fat white cross to a skinny black cross, click and drag down Column B as far as needed. XL will *automatically* change the cell reference in the formula to match the row that the formula is in. If you have no blank rows in Column A between your numbers, you can have XL *automatically* copy the formula down Column B, as far as there are numbers in Column A, by *double clicking* on that tiny black square when the cursor changes to the skinny black cross.  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > How to multiply entire colume with constant: > [quoted text clipped - 18 lines] > > Thank you. In re-reading your post, here's the procedure that I believe you alluded to: Click in B1 and drag down to select as many rows as you need. With B1 the cell in focus (colored white), type in this formula: =A1*7 THEN, hold down <Ctrl> and hit <Enter>. This will fill all the selected cells in Column B with the formula. Is that what you were after? SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Say your numbers start in A1. > In B1, enter this formula: [quoted text clipped - 37 lines] > > > > Thank you. Or, alternately, do the first part of what you said in your first post (put =A1*7 in B1; click back in B1 to select it) and then simply double-click that little black square. Rick > In re-reading your post, here's the procedure that I believe you alluded > to: [quoted text clipped - 59 lines] >> > >> > Thank you. It appears that you didn't read my first post in it's entirety!<bg> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Or, alternately, do the first part of what you said in your first post (put > =A1*7 in B1; click back in B1 to select it) and then simply double-click [quoted text clipped - 73 lines] > >> > > >> > Thank you. So, then, you are saying one of the key things to do when reading newsgroup messages is to use the scroll bar too?<g> I could say, "Sorry for having missed that in your message", but let's just say I was reinforcing your point instead, okay?<vbg> Rick > It appears that you didn't read my first post in it's entirety!<bg> >> Or, alternately, do the first part of what you said in your first post [quoted text clipped - 87 lines] >> >> > >> >> > Thank you. Your reinforcement is greatly appreciated!<bg> SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- So, then, you are saying one of the key things to do when reading newsgroup messages is to use the scroll bar too?<g> I could say, "Sorry for having missed that in your message", but let's just say I was reinforcing your point instead, okay?<vbg> Rick > It appears that you didn't read my first post in it's entirety!<bg> >> Or, alternately, do the first part of what you said in your first post [quoted text clipped - 89 lines] >> >> > >> >> > Thank you. Actually this is what I am after: Column A (qty) Column B (unit Price) Column C (total price) 21 7 147 26 7 182 28 8 224 33 8 264 77 10 770 Colume A and B are known. Column C is variable. Is there anyway to insert one simple same formula into all the cells in column C. Also, how to insert one formula into all the cells in column C? Can we avoid cell specific, such as using A1, becuase the cell name will change after sorted and moved into both different column and row of department master account? Thank you for you'all The formula simply now becomes: =A1*B1 Follow any one of the numerous procedures in the above posts to copy it down Column C. As far as moving and sorting: You might try copying, and then use "Paste Special" - "Values", so that only the data is duplicated in those other locations. That way you could sort however you wished. SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > > Actually this is what I am after: [quoted text clipped - 19 lines] > > Thank you for you'all > The formula simply now becomes: > [quoted text clipped - 8 lines] > > That way you could sort however you wished. What you show is typing each cell in Column C with this formula. I specically do not want cell specific formula. I seek a general purpose formula for paste into all cells in column C. Read again what RD said. You don't need to type separately in each cell in column C. If you read back through the thread you will see descriptions of numerous different easy ways of copying down the column. SignatureDavid Biddulph > What you show is typing each cell in Column C with this formula. > I specically do not want cell specific formula. > I seek a general purpose formula for paste into all cells in column C. >> The formula simply now becomes: >> [quoted text clipped - 8 lines] >> >> That way you could sort however you wished. RD, Thank you. > The formula simply now becomes: > [quoted text clipped - 28 lines] >> >> Thank you for you'all You're welcome, and thank you for the feed-back. SignatureRegards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- RD, Thank you. > The formula simply now becomes: > [quoted text clipped - 28 lines] >> >> Thank you for you'all Andrea Another approach: In C1 place the number 7, In B1 enter =A1:A5*$C$1. Then do what Ragdyer suggested to move the formula to the bottom of you data. if it has no blanks method work really fast! The nice part about this set up is if you need to change the multiplier (7) to a different number you can do so without changing anything else. Mike Rogers > How to multiply entire colume with constant: > [quoted text clipped - 18 lines] > > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.