Try this array* formula:

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

assuming your range of numbers occupies A1 to A9 - adjust as necessary.

* As this is an array formula, then once you have typed it in (or
subsequently edit it) you must use CTRL-SHIFT-ENTER (CSE) instead of
just ENTER. If you do this correctly then Excel will add curly braces {
} around the formula when viewed in the formula bar - you must not type
these yourself.

Hope this helps.

Pete

The Countryman wrote:

I am struggling to find a formula that will allow me to find the lowest
number within a range that doesn't include either blanks or 0's in the
answer. Does anyone know of a simple solution?

Thanks
--
Yorkie