"xp" wrote:
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).

First, it would be a good practice if you ensured that each formula rounded
to 2 decimal places, either by explicitly using the ROUND function
(preferred) or by using the "Precision As Displayed" calculation option in
conjunction with a number format other than General.

If you do that, then the following might meet your needs:

=COUNTIF(E1:E100,"<0")

Otherwise, try:

=SUMPRODUCT(--(ROUND(E1:E100,2)<0))

Note that these formulas return a count of non-zero values, not simply "if
every cell is zero". I think the count is more useful.

FYI, I usually do this inconjunction with a parallel column (e.g. F1:F100)
of the form:

=IF(ROUND(E1,2)=0,"","ERROR")

Then the first formula can be simply: =COUNTIF(F1:F100,"ERROR")


----- original message -----

"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!