1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Ideas on a formula for budgeting?

I can't remember a formula and Google/AI isn't helping because I don't think I can explain it simply enough.

Scenario: Current Budget is Cell N7. I was granted an additional Budget to add to the current budget. New Additional budget is in Cell L10.

I need a formula that would be placed in another cell, where the total in this cell starts with the New Additional Budget (Cell L10), and as I add budget to the original above, this will Zero out - so I know I've allocated all the new budget to the original. Any ideas? Thank you!

https://preview.redd.it/uufrg1xpl7qg1.png?width=1122&format=png&auto=webp&s=3d2682ee07ffaee844882e94e3560fa1db943a14

submitted by /u/Oywiththespots
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#formula generator
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#google sheets
#row zero
#financial modeling with spreadsheets
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#budget
#formula
#Excel
#current budget
#additional budget
#cell N7
#cell L10
#total
#allocate