Open Office Spreadsheet Calculations

I need to fill in price fields in our billing system, and I need to basically do 6 * 1.99, 8 * 1.99, 10 * 1.99, all the way through 64. Then do the same thing for 6 - 64 with 1.79$, then again with 6 - 64 with 1.59$.

I was doing this manually by hand, and just using Windows Calculator, but I rea开发者_如何学Pythonlized it was going to take forever. I was going to write a small program in C# to do it, but would there be an easy way to do this with calculations in Open Office Spreadsheet?

I would just need to do something like =A1*B1, =A2*B1, etc.

Would there be anyway to do something like...A(This row index)*B(This row index) though? Would it be possible to have it automatically fill out these fields with that formula?

So you can do the following:

You can write the prices in column A (starting with row 2 1,99, 1,59...) and all the numbers in row 1 (starting with column B 6,8,12....)

if you have this you can just put:

B$1*$A2

Into coulm b2.

Now you can paste this formula by dragging the spot at the cell corner to other cells. The Row number will automaticly change.

Use ROW() to get the current row number. So for example, you could use a series of formulas like this:

=(ROW() + 2) * 2  |  =A1*1.99  |  =A1*1.79  |  =A1*1.59

Then copy the formulas down as many rows as needed.

Put the price in A1 and use it in your formulas as $A$1, this way its row and column will not progress as you drag your formula down or to the right.