Min function without zeros
 

I have a spreadsheet with 4 cells in four different worksheets that I want to
find the min value that isn't zero. How can I make the Min function work and
not pick up the zero?

Min function without zeros
 

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

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"dragea" wrote in message
...
I have a spreadsheet with 4 cells in four different worksheets that I want
to
find the min value that isn't zero. How can I make the Min function work
and
not pick up the zero?

Min function without zeros
 

I tried the formula but it gives me an error because all the cells aren't
together in the same worksheet. Here is what I tried
=MIN(IF('Admissions Monthly'!AD129,'Adolescent Monthly'!AD129,'GAC
Monthly'!AD129,'GAD Monthly'!AD129<0,'Admissions Monthly'!AD129,'Adolescent
Monthly'!AD129,'GAC Monthly'!AD129,'GAD Monthly'!AD129))

"Bob Phillips" wrote:

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

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"dragea" wrote in message
...
I have a spreadsheet with 4 cells in four different worksheets that I want
to
find the min value that isn't zero. How can I make the Min function work
and
not pick up the zero?