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??? |
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 |
All times are GMT +1. The time now is 10:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com