I was wondering if there is a way to make a formula to automatically adjust so that the sum of a column doesn't a certain maximum.
For example: I want to contribute $10,000 to a charity, taking 10% of my income. My income varies per month, so I will probably hit the $10,000 limit earlier. For simplicity's sake, 10% of my income (in a perfect world):
- Jan - $2500
- Feb - $2500
- Mar - $4000
- Apr - $3000
- May - who cares.
I'll hit the $10K in April and I'll go over.
Is there a function either at the final sum cell or within the individual months to not have to manually correct each month?