How do I increase all data in database by 5%

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to increase all prices in price sheet by certain percent? 6
Excel 2
how do i increase the value of numbers in a column by a percentage 5
increase column by % 3
Avg. price increase 3
Add Same in amount in whole Column 21
How do I increase a column of numbers by a percentage-same cell 3
Conditional Formatting - Increases/Decreases 4

Back
Top