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 di...
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
Which cell do I copy and paste down the column (C) in oreder to get it to do it automatically?
I really appreciae your help with this.
Kate
Kate, stay on C5 and drug it down by the dot at bottom down corner
I just copied and dragged down C5 and it changed everything to 97.89
I just don't know what I am doing incorrectly. I put the formula exactly as you have it, into C5 and what comes up in C5 is $0.00
Please check attached file