| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding % to existing cell values
I should know this....but, how do I add 4% to a range of cells?
(I'm trying to update a price sheet by increasing the % on existing prices) Thanks! -- John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding % to existing cell values
1. Type 1.04 in some empty cell.
2. Edit/Copy that cell 3. Select the cells containing the prices 4. Edit/Paste Special and select the Values and Multiply options. On Wed, 12 Dec 2007 10:10:01 -0800, John wrote: I should know this....but, how do I add 4% to a range of cells? (I'm trying to update a price sheet by increasing the % on existing prices) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding % to existing cell values
Put 1.04 in a spare cell. Copy, select your range of cells, then Edit/
Paste Special/ Multiply. -- David Biddulph "John" wrote in message ... I should know this....but, how do I add 4% to a range of cells? (I'm trying to update a price sheet by increasing the % on existing prices) Thanks! -- John |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding % to existing cell values
put 1.04 in an empty cell
Edit|copy (that cell) select the range to fix Edit|paste special|check multiply John wrote: I should know this....but, how do I add 4% to a range of cells? (I'm trying to update a price sheet by increasing the % on existing prices) Thanks! -- John -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding % to existing cell values
Enter 1.04 in an empty cell
Copy that cell: EditCopy Select the cells you want to increase Then, EditPaste SpecialMultiplyOK -- Biff Microsoft Excel MVP "John" wrote in message ... I should know this....but, how do I add 4% to a range of cells? (I'm trying to update a price sheet by increasing the % on existing prices) Thanks! -- John |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding % to existing cell values
Enter 1.04 in an unused cell.
Copy that cell. Select the range to change and EditPaste SpecialMultiplyOKEsc. Delete the cell with 1.04 Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 10:10:01 -0800, John wrote: I should know this....but, how do I add 4% to a range of cells? (I'm trying to update a price sheet by increasing the % on existing prices) Thanks! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding % to existing cell values
Thanks! (all) That did it! I knew it was something not too complicated. I
appreciate it. -- John "Myrna Larson" wrote: 1. Type 1.04 in some empty cell. 2. Edit/Copy that cell 3. Select the cells containing the prices 4. Edit/Paste Special and select the Values and Multiply options. On Wed, 12 Dec 2007 10:10:01 -0800, John wrote: I should know this....but, how do I add 4% to a range of cells? (I'm trying to update a price sheet by increasing the % on existing prices) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding a line to an existing chart | Charts and Charting in Excel | |||
| ADDING MORE WORKSHEETS TO AN EXISTING WORKBOOK | Excel Discussion (Misc queries) | |||
| adding data to existing data cell | Excel Worksheet Functions | |||
| ADDING NEW NUMBERS TO EXISTING WORKSHEET | New Users to Excel | |||
| adding formula to existing database | Excel Worksheet Functions | |||
Linear Mode
