Formula

[AFP123]

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. 

[#2 · Accepted 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.

[#3]

@Riny_van_Eekelen 

Amazing! Thank you so much. Very helpful