| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
make a single cell always equal zero
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| make cell length always equal 10 | Excel Discussion (Misc queries) | |||
| make a cell equal a worksheet name | Excel Discussion (Misc queries) | |||
| can I make worksheet name equal a cell | Excel Worksheet Functions | |||
| How do I make one cell equal to another | Excel Worksheet Functions | |||
Threaded Mode
