| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I increase a table values by 1.2 for example?
I have a table with quarters in rows and values in columns. I need to
increase all values by some factor (lets say number in cell A1). I know that I can multiply every cell separatelly. Is there any other, more automatic way? |
|
#2
|
|||
|
|||
|
Copy a cell that contains the value 1.2. Now select all the cells you want
to increase. Hit Edit--Paste special, Multiply. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Michal" wrote in message ... I have a table with quarters in rows and values in columns. I need to increase all values by some factor (lets say number in cell A1). I know that I can multiply every cell separatelly. Is there any other, more automatic way? |
|
#3
|
|||
|
|||
|
Well OK, but I would like to have pasted the A1 cell instead of 1.2 value
into selected cells, so if I change the A1 value from 1.2 to 1.5 all selected cells will be multiplied by this factor. "Anne Troy" wrote: Copy a cell that contains the value 1.2. Now select all the cells you want to increase. Hit Edit--Paste special, Multiply. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Michal" wrote in message ... I have a table with quarters in rows and values in columns. I need to increase all values by some factor (lets say number in cell A1). I know that I can multiply every cell separatelly. Is there any other, more automatic way? |
|
#4
|
|||
|
|||
|
That's fine, but then you have to put a formula next to each cell:
If your values are in A2 to A10, then in B2, put =A2*A1 Then copy down. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Michal" wrote in message ... Well OK, but I would like to have pasted the A1 cell instead of 1.2 value into selected cells, so if I change the A1 value from 1.2 to 1.5 all selected cells will be multiplied by this factor. "Anne Troy" wrote: Copy a cell that contains the value 1.2. Now select all the cells you want to increase. Hit Edit--Paste special, Multiply. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Michal" wrote in message ... I have a table with quarters in rows and values in columns. I need to increase all values by some factor (lets say number in cell A1). I know that I can multiply every cell separatelly. Is there any other, more automatic way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't pasted values from a formula appear in a pivot table | Excel Discussion (Misc queries) | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Do not show rows with no values in Pivot Table | Excel Discussion (Misc queries) | |||
| How to increase the size of a Pivot Table Graph | Excel Discussion (Misc queries) | |||
| how can i fill a table with values from repeated regressions | Excel Worksheet Functions | |||
Linear Mode
