Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase a currency grid values by 3%
I have a salary chart that I am trying to add 3% increase to the whole grid
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase a currency grid values by 3%
put 1.03 in an empty cell
select that cell edit|copy Select the range to fix edit|Paste special|Check multiply Clean up that "helper" cell Kate/comp wrote: I have a salary chart that I am trying to add 3% increase to the whole grid -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase a currency grid values by 3%
You can change the values by
sub upit() for each c in selection c.value=c*1.03 next c end sub -- Don Guillett SalesAid Software "Kate/comp" wrote in message ... I have a salary chart that I am trying to add 3% increase to the whole grid |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increase a currency grid values by 3%
In an empty cell, enter 1.03
Edit|Copy Select your data Edit|Paste Special, check Multiply -- Kind regards, Niek Otten Microsoft MVP - Excel "Kate/comp" wrote in message ... |I have a salary chart that I am trying to add 3% increase to the whole grid |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
How do I increase a table values by 1.2 for example? | Excel Worksheet Functions | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel |