How do I increase all data in database by 5%

B

Bluejeans

I have a database which lists the price of several hun dred items. I want to
increase the price of each one by 5%. Is there a formula for this ?
 
J

JulieD

Hi

type 1.05 in an unused cell somewhere and copy it, select the numbers you
want to increase and choose edit / paste special - multiply - OK

(note, would suggest doing this on a copy of your workbook first, just in
case)
 
D

Duke Carey

Not a formula, per se. Before doing this, make sure you have a back up copy.

In an empty cell type 1.05. Copy the cell. Select all the prices. From
the menu choose Edit>Paste Special>Multiply
 
Top