| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula that checks balances
I have a long list of formulas in column "E".
I need to know at a glance whether any value in this column is inequal to zero without having to page down all the way through thousands of rows. Summing the column is no good because there could be offsetting values (e.g. +5 + -5 = 0). I would like a formula I could place in one cell that would indicate if every formula in the column evaluates to zero or not (rounded to 2 decimals). Can anyone help? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help with creating a formula which checks more than 40 cells | Excel Worksheet Functions | |||
| Formula that checks several criteria before returing the value??? | Excel Discussion (Misc queries) | |||
| Formula/function that checks for a set of values. | Excel Worksheet Functions | |||
| formula to check balances within parameters | Excel Worksheet Functions | |||
| How to link endings balances to beginning balances on different sh | Excel Worksheet Functions | |||
Threaded Mode
