Forum Discussion
Kathleen Sekula
Jun 26, 2017Copper Contributor
% 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...
SergeiBaklan
Jun 26, 2017Diamond Contributor
Kate, when something like this where the formula entered into C5 and when copied down
Kathleen Sekula
Jun 26, 2017Copper Contributor
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
- Kathleen SekulaJun 26, 2017Copper Contributor
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
- SergeiBaklanJun 26, 2017Diamond Contributor
Kate, stay on C5 and drug it down by the dot at bottom down corner
- Kathleen SekulaJun 26, 2017Copper Contributor
I just copied and dragged down C5 and it changed everything to 97.89
- SergeiBaklanJun 26, 2017Diamond Contributor
Oops... Do you have 90.90 in C5 before you copy? And please check absolute and relative references in formula, is it B5-1 (not B$5-1)?