I have an amount that I have to distribute over 3 years. Distribution needs to be such that there is an amount for Year 1, Year 2 amount will be 10% of Year 1 amount and Year 3 amount will be 10% of Year 2 amount.
An example is:
Cell D2 contains 3,310
I need to display the following in cells A2, B2 and C2:
A2 = 1,000
B2 = 1,100
C2 = 1,210
Right now, I am doing it with trial and error but it would be great and safe if Excel has any functionality for this.
An example is:
Cell D2 contains 3,310
I need to display the following in cells A2, B2 and C2:
A2 = 1,000
B2 = 1,100
C2 = 1,210
Right now, I am doing it with trial and error but it would be great and safe if Excel has any functionality for this.