Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing all values in spreadsheet by same percentage.
I would like to know a simple way to increase all values in data cells by the
same percentage. I can't figure out how to write the formula that will increase the value and add it it the current number in each cell of the spreadsheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing all values in spreadsheet by same percentage.
Say you want to increase a range of numbers by 38%
Put 1.38 in an empty cell Edit|copy (that cell) Select the range to adjust Edit|Paste special|check Multiply and Values Then clean up that cell with the 1.38 in it. Excels Alot wrote: I would like to know a simple way to increase all values in data cells by the same percentage. I can't figure out how to write the formula that will increase the value and add it it the current number in each cell of the spreadsheet. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increasing a whole Spreadsheet by a percent | Excel Discussion (Misc queries) | |||
increasing percentage | Excel Worksheet Functions | |||
Increasing the Default size of a spreadsheet | Excel Discussion (Misc queries) | |||
Increasing numbers in a column by percentage | Excel Worksheet Functions | |||
increasing spreadsheet size | Excel Discussion (Misc queries) |