Forum Discussion
Restricting cells from equaling above a value
Here's a further cleaning up of the last version. Made to be a bit more flexible. You can just enter any annual goal in cell A1 and have it apportioned out equally among the months.
Then enter the actual for each month as that actual is known; the subsequent months are adjusted so that the annual goal is shown as still achievable.
I've added a bit more documentation, including brief explanations of the two most significant formulas.
Here's a further cleaning up of the last version. Made to be a bit more flexible. You can just enter any annual goal in cell A1 and have it apportioned out equally among the months.
Then enter the actual for each month as that actual is known; the subsequent months are adjusted so that the annual goal is shown as still achievable.
I've added a bit more documentation, including brief explanations of the two most significant formulas.
- Thank you so much for all the help! This will work for me, and I will make some other adjustments. You're the best!
- You're very welcome. It was a very interesting project.