| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
percenatge increase in values across multiple cells
Hi
I have a spreadsheet of numerical values and I simply want to increase all values, in all cells, by 17.5%. Can anyone please tell me how to do this? Many thanks David |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
percenatge increase in values across multiple cells
David
Type 1.175 in a spare cell and copy it... Highlight your numbers and then editpaste special...values+multiply -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "David" wrote in message ... Hi I have a spreadsheet of numerical values and I simply want to increase all values, in all cells, by 17.5%. Can anyone please tell me how to do this? Many thanks David |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
percenatge increase in values across multiple cells
Many thanks for this. Saved me a lot of mouse work! Why the help couldn't
explain this I don;t know...too concerned with complex things and forgets the fundamentals. Cheers David "Nick Hodge" wrote in message ... David Type 1.175 in a spare cell and copy it... Highlight your numbers and then editpaste special...values+multiply -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "David" wrote in message ... Hi I have a spreadsheet of numerical values and I simply want to increase all values, in all cells, by 17.5%. Can anyone please tell me how to do this? Many thanks David |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offsetting values of multiple cells! | Excel Worksheet Functions | |||
| Find values from cells in multiple sheets | Excel Worksheet Functions | |||
| Simultaneously change values in multiple cells? | Excel Worksheet Functions | |||
| Values for Y and N in multiple cells | Excel Discussion (Misc queries) | |||
| Multiple X-Axis Values | Charts and Charting in Excel | |||
Linear Mode
