I'm using the compound annual growth rate formula =(x-y)^(1/P)-1 and I am hoping to make P variable based on the first year that money is deposited. I have a chart where we could input data for each year, and it spits out the compound annual growth rate for each year. Currently the formula works if money is deposited in the first year. However I'd like to alter it such that if money isn't deposited until say, year 3, each value of P would decrease by 2.
Solved by Z. L. in 30 mins