I need to write a formula or a function that divides all the numbers from the previous year without having to input it manually.
For example,
Year 1 1 20
Year 2 2 30
Year 3 3 40
Year 4 4 50
So I need 20/1 , 30/(1*2), 40/(1*2*3), 50/(1*2*3*4).
I have about 400 cells that I need to do so I can't input it manually. Is there a function i can use to solve this problem.
For those that know finance, I am try to discount cash flows where each year has a different interest.
Thanks for any help.
Bookmarks