software

I have a series of calculations that I need to use the MIN formula. the
problem is that many of the cells can have a 0(zero) value and not just
blank. Is there a way to find the minimum value but ignore the 0's? Otherwise
the minimum is always 0.

Thanks

Try this array formula:

=MIN(IF(A1:A100gt;0,A1:A100))

Use Ctrl-Shift-Enter to commit an array formula instead of just Enter. If
done correctly, it should appear with { } around it.

HTH,
Elkarquot;seedy3quot; wrote:

gt; I have a series of calculations that I need to use the MIN formula. the
gt; problem is that many of the cells can have a 0(zero) value and not just
gt; blank. Is there a way to find the minimum value but ignore the 0's? Otherwise
gt; the minimum is always 0.
gt;
gt; Thanks

Try Tools, Options, View, and uncheck Zero Values toward the bottom. That
should hide all zero values.

quot;seedy3quot; wrote:

gt; I have a series of calculations that I need to use the MIN formula. the
gt; problem is that many of the cells can have a 0(zero) value and not just
gt; blank. Is there a way to find the minimum value but ignore the 0's? Otherwise
gt; the minimum is always 0.
gt;
gt; Thanks

Thanks, those suggestions both were a great help