| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to scale existing table data.
We have excel spreadsheet pricebooks and we just implemented a 15% price
increase and I was looking for an easy way to update all the data, scaling it up by 15% |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to scale existing table data.
Hi,
You need to use a helper column as follow: =ROUND(A1*1.15,2) assumed your original data is in colunm A and your colomn helper is B then enter above formula to the cell B1 and copy drag to where ever you want and then copy past special value in the original column. Thanks, -- Farhad Hodjat "jeremy" wrote: We have excel spreadsheet pricebooks and we just implemented a 15% price increase and I was looking for an easy way to update all the data, scaling it up by 15% |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to scale existing table data.
In an un-used cell enter:
1.15 and copy the cell. Select all the cells you wish to scale and Edit PasteSpecial with Multiply checked. -- Gary''s Student - gsnu200723 "jeremy" wrote: We have excel spreadsheet pricebooks and we just implemented a 15% price increase and I was looking for an easy way to update all the data, scaling it up by 15% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scale of Data Table in Graph Object | Charts and Charting in Excel | |||
| Keeping existing data in table | Excel Discussion (Misc queries) | |||
| Increasing the Source Data range for an existing Pivot Table | Excel Worksheet Functions | |||
| Is it possible to import external data into existing pivote table | Excel Discussion (Misc queries) | |||
| how can I change the scale of the numbers in my chart data table? | Charts and Charting in Excel | |||
Linear Mode
