View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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