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!
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!
Oh Great!!, this works too, i'll use it too, thanks!.