Visit Jeremy's Blog.
 Home Forums HCL Reviews Tutorials Articles Register Search Today's Posts Mark Forums Read
 LinuxQuestions.org OpenOffice Calc formula question
 Linux - Software This forum is for Software issues. Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

 08-16-2004, 01:32 PM #1 Bigun Member   Registered: Aug 2002 Location: Hickville, TN Distribution: Gentoo > current. Have used: Red Hat 7.3, 9, Gentoo 1.4 Posts: 400 Rep: OpenOffice Calc formula question Ok... I'm making a spreadsheet that is about 65 rows by 4 columns... and without writting a special formula for each and every cell, is there anyway to do the following: Like say I was working on row 4. On that row I have columns A,B,C, and D. Now, if I wanted to multiply B4 by D4 and have A4 be the result. That wouldn't be too big a deal except I would have to rewrite the formula 64 times for each row! Is there a simpler way to make just 1 formula and copy and paste it to each cell so that the math will work with that row only?
 08-16-2004, 02:27 PM #2 bigrigdriver LQ Addict Contributing Member   Registered: Jul 2002 Location: East Centra Illinois, USA Distribution: Debian stable Posts: 5,893 Rep: OK. 65 rows, using columns A, B, and D, as you have shown (which omits column C from calculations). In the first row (assuming A1 is the first cell you want to use), enter this formula: =B1*D1 .That will multiply the values in cells B and D, and show the result in A1. To copy the formula to the remaining 64 cells, grab the handle in the bottom right corner of cell A1, and drag it down to cell A65. That will repeat the formula in all cells in column A, with relative cell references (that is, A2 will have B2*D2, A3 will have B3*D3, etc.). Notice that I did not use the \$ in front of the row or column references. That would signify absolute cell reference, and would not change the cell reference as you drag down to A65.
08-16-2004, 03:07 PM   #3
Bigun
Member

Registered: Aug 2002
Location: Hickville, TN
Distribution: Gentoo > current. Have used: Red Hat 7.3, 9, Gentoo 1.4
Posts: 400

Original Poster
Rep:
Quote:
 Originally posted by bigrigdriver OK. 65 rows, using columns A, B, and D, as you have shown (which omits column C from calculations). In the first row (assuming A1 is the first cell you want to use), enter this formula: =B1*D1 .That will multiply the values in cells B and D, and show the result in A1. To copy the formula to the remaining 64 cells, grab the handle in the bottom right corner of cell A1, and drag it down to cell A65. That will repeat the formula in all cells in column A, with relative cell references (that is, A2 will have B2*D2, A3 will have B3*D3, etc.). Notice that I did not use the \$ in front of the row or column references. That would signify absolute cell reference, and would not change the cell reference as you drag down to A65.
Thanks, worked like a charm.

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post philosophe Linux - Software 1 03-30-2005 05:32 AM BorisMcHack Linux - Software 0 01-31-2005 11:49 AM buffed317 Linux - General 1 09-11-2004 03:27 PM marsques Linux - Software 2 07-10-2004 04:30 PM hellblade Linux - Software 2 04-29-2004 11:23 AM

LinuxQuestions.org

All times are GMT -5. The time now is 01:53 PM.

 Contact Us - Advertising Info - Rules - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -