Forum Discussion
% Increase Calculations
Can anyone tell me how to calculate the following: Yearly % increase on hourly rate. Hourly rate is $88.68 and yearly increase is 1.025. I haven't used Excel for awhile and cannot figure out how I did this before. Any help will be greatly appreciated. Kate
10 Replies
- Sergie, I want to calculate a 1.02 increase over seven years on a base hourly rate of $88.68 per hour. What increase would they see each year? And so for year two it would be 88.68*1.025. Year three would be the rate at year two times 1.025% and so on. How do I calculate it on an excel sheet?
Kate, when something like this where the formula entered into C5 and when copied down
Okay, One thing I forget was to put the 1.025 into C1. I can compute by adding the formula to each cell in C but could not copy and paste down the C cells in order to do it automatically
Hi Kate,
I din't catch the question. If something becomes 1.025 times more that means it increases on 2.5%.
