LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   OpenOffice Calc formula question (http://www.linuxquestions.org/questions/linux-software-2/openoffice-calc-formula-question-218372/)

 Bigun 08-16-2004 01:32 PM

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?

 bigrigdriver 08-16-2004 02:27 PM

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.

 Bigun 08-16-2004 03:07 PM

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.

 All times are GMT -5. The time now is 11:26 AM.