SOLVED

Formula

New Contributor

Hi, 

I need to figure out a formula for this cash flow. We have it set-up so that it divides the balance by the correct number of years. The additional part is that we need to figure out how to get it to calculate correctly if the first year of the donations is going to start in FY23/FY24/FY25 and then divide the balance over the next 1-5 years. 

AFP123_0-1652917367066.pngAFP123_1-1652917385958.png

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@AFP123 The screenshot doesn't show the cell references, so please refer to the attached example that contains the type of formula you need.

Screenshot 2022-05-19 at 05.43.07.png

 

@Riny_van_Eekelen 

 

Amazing! Thank you so much. Very helpful