Desperados77
New Member
- Joined
- Sep 18, 2019
- Messages
- 2
Okay, so question i have is this, i have a budget sheet that has the monthly bills in their own cell and my net on top and the leftover on the bottom. so basically the leftover formula is the sum of the positive currency minus the bills.
so what i am trying to do is once the payment is taken out by the bank i want to update the spreadsheet by either graying out the bill amount so its no longer valid since its paid, but i want to see still how much i paid. basically i want the leftover formula not to count that value. Because i then update the net part with what is in the bank.
image attached,
so what i am trying to do is once the payment is taken out by the bank i want to update the spreadsheet by either graying out the bill amount so its no longer valid since its paid, but i want to see still how much i paid. basically i want the leftover formula not to count that value. Because i then update the net part with what is in the bank.
image attached,
