| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Formula Error
I have a very large spreadsheet of figures that I'd like to add a 9% markup
to. To calculate the 9% we divide the value by .91. How do I apply this formula to every selected value in the sheet without having to manually calculate each value??? |
|
#2
|
|||
|
|||
|
Excel Formula Error
Put 9% in an empty cell
select that cell edit|copy select your cells to fix edit|paste special|check multiply. Clean up that cell with 9%. VikiFynn wrote: I have a very large spreadsheet of figures that I'd like to add a 9% markup to. To calculate the 9% we divide the value by .91. How do I apply this formula to every selected value in the sheet without having to manually calculate each value??? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| Excel error message | Excel Discussion (Misc queries) | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Linear Mode
