make a single cell always equal zero
Not sure I fully understand, but perhaps you mean:
=-B1
Hope this helps.
Pete
On Jun 30, 5:58*am, Brad Best <Brad
wrote:
the problem I am facing is a I think a simple one and based on the posted
question and answers I have been reading I'm very sure much simpler than I'm
making it.
I would like my budget spread sheet to auto balance itself to automate the
entry of pending payments and outgoing bills. *I want the "Totals" cell to
always equal zero, taking any overage or underage from a single cell:
* * A * * * * * * *B * * * * * * *C
11Savings * * * $121.08 $121.08
12 * * *$0.00 * Balance
13Total $1,646.64 * * * $0.00
C3 I want to always to equal 0 drawing + or - from B1
Can this be done: *any help would be greatly appreciated
Brad Best
|