percentage increase
Enter 1.01 in an empty cell.
Copy it. Select the range of cells you want to increase by 1%. Paste special--Multiply. Click ok. Dave -- Brevity is the soul of wit. "michelplantz" wrote: I need to increase a column of dollar values by 1%. Is there a formula or function that will allow me to do this in a simple way, without having to enter a formula for each one? This will be a yearly thing I need to do and the formula or function needs to be kept hidden. |
All times are GMT +1. The time now is 07:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com