I'm sorry I needed the lowest positive number above 0. When I use this it
comes back with the lowest -number.

Thanks

"Don Guillett" wrote:

> try this. It is an array formula so must be entered/edited with
> ctrl+shift+enter and will not work on full columns.
>
> =MIN(IF(D1:D100>0,D1:D100))
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Tommy" <Tommy@discussions.microsoft.com> wrote in message
> news:D97567B8-E81D-48A6-B6F8-1B8CFF668646@microsoft.com...
> > I have a cell that has number ranges from -37 to 88, what is the formula
> to
> > show the lowest positive number.
> >
> > Thank You
>
>
>