=IFS(C14=YEAR(D8),(E8/H3),C14=YEAR(D9),(E9/H4),C14=YEAR(D10),(E10/H5))
Above is my formula that is not working.
I am trying to get a spreadsheet that automatically distributes the budget evenly based on each year by month. Does anyone have advice on how to correct my formula?
<tbody>
</tbody>
Above is my formula that is not working.
I am trying to get a spreadsheet that automatically distributes the budget evenly based on each year by month. Does anyone have advice on how to correct my formula?
| C | D | E | F | G | H | |
| 2 | Project Name | XYZ | Year | Month | ||
| 3 | Start Date | 2/5/19 | 2019 | 1 | ||
| 4 | Completion Date | 12/5/20 | 2020 | 12 | ||
| 5 | 2021 | 12 | ||||
| 6 | ||||||
| 7 | ||||||
| 8 | FY Budget | 2019 | $400,000 | |||
| 9 | FY Budget | 2020 | $200,000 | |||
| 10 | FY Budget | 2021 | $100,000 | |||
| Month | Planned Cost | |||||
| 12/5/19 | This is where the formula would go | |||||
| 1/5/20 |
<tbody>
</tbody>
Last edited:
