|
Registered
Join Date: Jul 2008
Location: Calgary, Alberta
Posts: 76
|
If you are just doing 30 years ie 6 iterations copy paste is your friend In other words do by brute force.
If it must be in formula =IF(("year"-"original year")>=5,TRUNC(("year"-"Original Year")/5)*Interest rate increment"+"Original Interest Rate","Original Interest Rate")
Year varies all other variable are fixed ( ie $C$3)
What you are doing is dividing the difference in the years by 5 truncating the result to an integer and multiplying the rate increment by the integer.
easy peasy
|