I have a spreadsheet with 3 columns. Part Number, Description and Price. The price is dealer price. What I want to do is change the price by doubling it and adding .0825% tax. The price column is about 250 items long.
I am having a difficult time since I am new to spreadsheet application,
Can someone help me to figure out formula?
John Houghton
jhough1832.at.gmail.com
Making up a price list
-
johnhoughton
- Posts: 1
- Joined: Mon Feb 02, 2009 9:44 pm
Making up a price list
Last edited by acknak on Mon Feb 02, 2009 11:16 pm, edited 1 time in total.
Reason: Disable active email address
Reason: Disable active email address
OOo 3.0.X on Ms Windows XP
Re: Making up a price list
{I edited your email address--otherwise, it's likely to be "harvested" as a target for spam]
If you have part, description, price in A2, B2 and C2, then in D2, put =C1*2+(C1*2*0.0825), or roll it all up as =C1*2.165. (I assume you mean that the tax is 8.25%, or 0.0825, and not 0.0825%, or 0.000825.
Whatever formula you put in D1, click on the fill handle (the blob in the lower right corner of the current cell highlight) and drag that down to include all the cells in column D that have data in columns A-C. You can just drag the mouse off the grid on the bottom and Calc will scroll down. When you see the end of your data, just move the mouse back over the cell grid and the scrolling will stop. Then you can move to the exact cell and release the mouse button.
That will copy the formula from the first cell to each of the other cells, adjusting each copy to use the data from it's own row.
As you get comfortable with that, you may want to use separate formulas, one to calculate the markup and one to calculate the tax, and one to add them together, and move the markup and the tax off to their own cells. That way you can adjust them all separately, if necessary, without having to edit the actual formulas.
If you have part, description, price in A2, B2 and C2, then in D2, put =C1*2+(C1*2*0.0825), or roll it all up as =C1*2.165. (I assume you mean that the tax is 8.25%, or 0.0825, and not 0.0825%, or 0.000825.
Whatever formula you put in D1, click on the fill handle (the blob in the lower right corner of the current cell highlight) and drag that down to include all the cells in column D that have data in columns A-C. You can just drag the mouse off the grid on the bottom and Calc will scroll down. When you see the end of your data, just move the mouse back over the cell grid and the scrolling will stop. Then you can move to the exact cell and release the mouse button.
That will copy the formula from the first cell to each of the other cells, adjusting each copy to use the data from it's own row.
As you get comfortable with that, you may want to use separate formulas, one to calculate the markup and one to calculate the tax, and one to add them together, and move the markup and the tax off to their own cells. That way you can adjust them all separately, if necessary, without having to edit the actual formulas.
AOO4/LO5 • Linux • Fedora 23