On May 4, 1:15*am, FSt1 wrote:
hi
use a countif formula
=countif(E2:E10,0)
the above would tell you if you have any formulas that equate to zero.
to find where that is use the following....
=ADDRESS(MATCH(0,E2:E10,0),1,1)
the above will only show the first instance of a zero value. in case you
have more than one.

regards
FSt1



"xp" wrote:
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!- Hide quoted text -

- Show quoted text -

One another
=SUM(E1:E100*E1:E100)
Just press Ctrl+Shift+Enter in place of Enter as this is an array
formula.
If any non zero value is there then the formula result will be 0

Or if you do not use formula one other way.

Select the E1:E100----If E1 is "0" then press Ctrl+Shift+\ ----
This will select all cells not "0"
In case the E1 is not zero you can make it 0 for time being.