Formula help to calculate annualized specific to a specific starting month

I have a formula working correctly, (thanks to Paul Newcome) where a month is entered and an amount (Annualized Project Impact ($)) which then populates to the correct months, based on that start date then carries across the remaining months.
Here is the existing formula for that =IF(MONTH([Planned Project Savings Start Date]@row) <= 1, [Annualized Project Impact ($)]@row / (12 - MONTH([Planned Project Savings Start Date]@row) + 1))
What I need to include is a formula that divides the "Annualized Project Impact ($)" by 12 then starts entry in the "Planned Project Savings Start Date" month.
For the below image the correct monthly amount should be $2,500 NOT $5,000
Answers
-
Including @Paul Newcome
I think your original formula was set up to split the Annualized Project Impact ($) across the remaining months of the year.
If you want it to be split across 12 months, starting in the month of the Planned Project Savings Start Date, you could use this formula:
Jan '23:
=IF(MONTH([Planned Project Savings Start Date]@row) <= 1, [Annualized Project Impact ($)]@row / 12)
Feb '23:
=IF(MONTH([Planned Project Savings Start Date]@row) <= 2, [Annualized Project Impact ($)]@row / 12)
And so on, just changing the month number in your formula for each column.
Paul, I'm curious if you have other ideas too!
-
@Julie Fortney Thanks for the tag.
@Lisa Welch Julie's solution should work for you based on the way I am reading your request.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!