PDA

View Full Version : Excel formula



fergie
28-06-2003, 08:32 PM
Hi.
This may be a really dumb/simple question, so don't laugh!
I have a database of prices per part from a range of places.
All i wanna do, is add a % (GST) and a set amount ($10 shipping)
Its an excel database file.
How do I go about doing it?
Cheers

Robin S_
28-06-2003, 10:38 PM
If your cost price is in eg cell B5 then - =(B5*1.125)+10 should do it.

fergie
28-06-2003, 10:46 PM
hi.
Only thing, i want to do prices in 5 columns, each about 20 rows deep - eg - 100 prices across 5 columns, 20 rows

parry
29-06-2003, 11:58 AM
Hi, Im not really sure what you are after as GST and shipping is not normally contained in the product prices for most businesses.

If you want to overwrite the existing product prices with a new figure that includes GST and + $10 then do the following...

1. In a blank cell type 1.125
2. Copy this cell
3. Select all the cells with prices
4. Select Edit-Paste Special and choose under the operation heading the option Multiply and click OK. Now all your prices include GST.
5. Overtype the cell with 1.125 with 10 and copy the cell
6. Select all the cells with prices
7. Select Edit-Paste Special and choose the option Add and click OK. Now all your prices have $10 added.
8 Delete the cell with 10

Hope this is what you were after.

fergie
29-06-2003, 12:20 PM
thanks Parry
Thats exactly what I was after :D