That is because you probably didn't array enter it. After typing the
formula, use Ctrl-Shift-Enter not just Enter to commit it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tommy" <Tommy@discussions.microsoft.com> wrote in message
news:926E1276-E7B9-4E06-84F0-E24330CD993D@microsoft.com...
> 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
> >
> >
> >