Forum Discussion
Solved
Series on excel
I have a value, 100 for example and a rate (5%) with a period on 3 years and use 90% of the result. I need to recreate this formula (100/3*((1+5%)³-1)+100/3*((1+5%)²-1)+100/3*((1+5%)-1)*90% So if i ...
HvgoCA As a variant, and if you are on a recent version of Excel, please find a formula in the attached workbook, using the SEQUENCE function. No VBA required.
Edit: updated file!
It's very simple put the value of n in any cell and use the cell address/references in the formula for example,,,
Suppose in cell A1 you kept value of n,, then this would be the formula.
=100/$A$1*((1+5%)²-1)+100/$A$1*((1+5%)-1)*90%
Suppose in cell A1 you kept value of n,, then this would be the formula.
=100/$A$1*((1+5%)²-1)+100/$A$1*((1+5%)-1)*90%