Hi All,
I am looking to use a formula to help distribute costs into a cashflow spreadsheet. I have attached a sample spreadsheet, ideally i would like to be able to have the value from cell D5 broken into different percentages and then distributed to months in the cashflow.
As an example to make payments to a builders the payments might be broken in 10% in month 1, 25% in month 3, 40% in month 8, 15% in month 11 and 10% in month 14. Example 1
If this isn't possible could I nominate a month that each payment would be made in and if there is no payment in that period then a $0 would be returned. Example 2
Kind Regards
Wade
Bookmarks