Cardan,

Assuming the range is A1:A100, this formula will give the smallest value and
ignores 0s and blanks.

=SMALL(A1:A100,COUNTIF(A1:A100,0)+IF(COUNTBLANK(A1 :A100)0,1,0))


--
Hope that helps.

Vergel Adriano


"cardan" wrote:

Hello All, I am trying to find the minimum number in a column range.
This range contains formulas that return a positive value or a 0. I am
trying to find the minimum number other than 0. I tried to rewrite the
formula so it would return "" other than 0. This works, however it
causes the VALUE error on other cells that are linked to this range
since there are no values. Is there a way to find the minimum above
zero? Any help would be greatly apprieciated! Thank you.

Dan