Question
Please see the image below. Starting out I want to input the amount just spent in the spent column, it automatically subtracts from the planned
Please see the image below. Starting out I want to input the amount just spent in the spent column, it automatically subtracts from the planned amount, and puts it in the remaining budget column. But then the next time I input in the spent column it subtracts it from the remaining budget column, that way I always know how much I have left to spend
Ex in case I'm not being clear: I go to the grocery store and spend $100 dollars. I put $100 in the spent column and hit enter, it then looks at my planned to spend column, subtracts $100 from the $1000 and inputs $900 into my remaining budget. Then the next time I go to the grocery store I spend $50. It now takes the $900 in the remaining budget column and subtracts the $50 inputted and puts $850 in the remaining budget and reverts the $50 just inputted into spent back to $0 so its clear the next time I want to input a number.
B B D E F 1 2 Income 5,846.00 5,846.00 Month Monthly Expenses Actual Spent 990.00 Remaining 3 Employment $ 4 Interest $ 5 Total $ 6 7 8 9 Mortgage $ 10 Insurance $ 11 Utilities $ 12 Gas $ 13 Eating Out $ 14 Child Care $ 15 Groceries $ 16 Lawn Service 17 Unknown Expen: $ 18 Car Expenses $ 19 Entertainement $ 20 Subtotal $ 21 Savings $ 22 Planned 990.00 $ 100.00 400.00 200.00 500.00 300.00 1,000.00 $70 286.00 300.00 700.00 4,846.00 $ 1,000.00 $ 990.00 4,856.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started