I have the following arrary formula which works well:
{=SUM(A1*(1+(A2/100))^{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19})}
However is there a way to change the list part (which is no. years) {0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19} to a input cell?
Ideally I'd like to enter say (Years=) 5 in a cell and return {0,1,2,3,4}
and 9 would return {0,1,2,3,4,5,6,7,8} etc.
Is this possible?
{=SUM(A1*(1+(A2/100))^{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19})}
However is there a way to change the list part (which is no. years) {0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19} to a input cell?
Ideally I'd like to enter say (Years=) 5 in a cell and return {0,1,2,3,4}
and 9 would return {0,1,2,3,4,5,6,7,8} etc.
Is this possible?