amartino44
Board Regular
- Joined
- Dec 12, 2012
- Messages
- 56
Hello. How would you create a earned revenue schedule formula for the following:
In row A, I have 24 months of sales. In row B, I would like the TOTAL EANRED sales amount. All sales are are earned at 8.33% per month. So, in January of the first year, 8.33% of January sales are earned. In February, 8.33% of January sales and 8.33% of February sales are earned (etc. etc). The sales from January stop earning out after 12 monts (12*8.33= 100%) I would like to create a formula for row B. Thank you
In row A, I have 24 months of sales. In row B, I would like the TOTAL EANRED sales amount. All sales are are earned at 8.33% per month. So, in January of the first year, 8.33% of January sales are earned. In February, 8.33% of January sales and 8.33% of February sales are earned (etc. etc). The sales from January stop earning out after 12 monts (12*8.33= 100%) I would like to create a formula for row B. Thank you