[SOLVED] If formula to allocate expenses per year

Hello,

Attached is the sheet I need help on.

We have June year end. I am trying to prepare an option expenses per year. I need to use a formula to allocate expenses per year (Column U to Z) based on the Vesting Commence Date (Column H) and the term (Some are one time, some are 48 months (4 years)). I am able to use a formula for the beginning years, but I can not think of a way that the expenses on the last term and stop onward.

Thanks for the help.

Jackson

In V4:

Formula:

Please Login or Register  to view this content.

and copy down/rihgt
blue is what I added to your formula. Note that column U has been left unchanged.

Glad to hear that and thanks for the reputation.
By the way: Would be nice, if you could select Thread Tools from the menu link above and mark this thread as SOLVED.
TIA.