Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ? |
#2
|
|||
|
|||
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 ? |
#3
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
Re-entering data into a Database | Excel Discussion (Misc queries) | |||
Macros to tranfer data to database | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |