| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to increase an entire collumn by a certain percentage?
I have a collumn of dollar amounts that I want to increase by a certain
mulaplier, say 35%. Is there any way to do this? The collumns are on average 30 rows long, with various amounts. |
|
#2
|
|||
|
|||
|
In an empty cell somewhere type 1.35 (for 35%). Then do the following:
1. Select and copy that cell with 1.35 in it 2. Then select the column of numbers that you want increased by 35% 3. Click Edit/Paste Special 4. Under Paste, select "Formulas" 5. Under Operation, select "Multiply" 6. Click OK "Josh" wrote: I have a collumn of dollar amounts that I want to increase by a certain mulaplier, say 35%. Is there any way to do this? The collumns are on average 30 rows long, with various amounts. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, can I shade entire rows based on the value of a single . | Excel Worksheet Functions | |||
| Percent increase | Excel Worksheet Functions | |||
| Help using Conditional Formating of Entire Rows | Excel Worksheet Functions | |||
| Excel should let me set the print default to "Entire Workbook". | Setting up and Configuration of Excel | |||
| Search should highlight entire row in Excell in red | Excel Discussion (Misc queries) | |||
Linear Mode
