Originally Posted by
Richard Buttrey
Now I'm really confused. How is U13 related to R40?
U13 has a positive budget that is messing up the percentages on the right. R40 is labeled as a "savings" line, and I would like any excess money listed in the U column to be transferred to R40.
The only thing I have found that is a possible work around is by making the formula in cell U13 be This formula would than be copied to cells U12-U47
and then in cell R40 I have the formula reading
243.70 is the baseline budget, the rest would then be adding any positive values. The problem is, if I were to continue this formula, it would be long and endless.
so, the updated question is, is there a way to shorten this formula:
Bookmarks