How do I increase all data in database by 5%
 

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 ?

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)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Bluejeans" wrote in message
...
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 ?

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 EditPaste SpecialMultiply


"Bluejeans" wrote:

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 ?