I've been trying to figure this out and I need some help. I'm working on a bid that extends out for several years. How do I show an increase of 3% per year in one cell. For instance, the original estimate was 2015, so there would be 5 years of 3% compound increase. I know how to show it in multiple cells, but just not in one. Thanks in advance.
Last edited by CLSSY56; 02-11-2020 at 11:18 AM.
-Travis
Mac OS 12.1
Excel 365 (v16.59)
Formula:
Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
If the starting number is in A1, the figure compounded at 3% for 5 years is
=A1*(1+0.03)^5
You can put the 3% in a cell instead of the formula, and the 5 years in a cell instead of the formula.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Thanks!
I combined your replies and came up with this.
=AB73*(1+(R74))^(T74-N74)
AB73 = SUB TOTAL
R74 = my percentage
T74 = Current year
N74 = 2015
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks