On Apr 22, 9:06 am, 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

Hi Dan,

This array formula seems to work on A1:A100 for example...

=MIN(IF(A1:A100<0,A1:A100))

After typing in the formula it has to be entered by pressing Ctrl +
Shift + Enter. After doing that it Excel will place it in curly
brackets.

Ken Johnson