| 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 | |||
Linear Mode
