LinuxAnswers - the LQ Linux tutorial section.
 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, 02: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, 03:27 PM #2 bigrigdriver LQ Addict Contributing Member   Registered: Jul 2002 Location: East Centra Illinois, USA Distribution: Debian Squeeze Posts: 5,805 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, 04: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.