# Thread: min >0 (97 SR2)

1. ## min >0 (97 SR2)

Is there a function that will return the Minimum value greater than zero from a range of cells?

2. ## Re: min >0 (97 SR2)

=MIN(IF(Range<>0,Range,FALSE)) this is an array formula. Enter using Ctrl+Shift+Enter
Also see:
http://www.cpearson.com/excel/lists.htm

3. ## Re: min >0 (97 SR2)

I got an error message. <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15> I suppose i should have stated that the columns containing the datea to be evaluated are not adjacent.
They are in \$AE22,\$AA22,\$W22,\$S22. I tried to substitute this in your formula surrounded by Parenthasies "(\$AE22,\$AA22,\$W22,\$S22)" for the word "Range"

4. ## Re: min >0 (97 SR2)

You could do something like this:

<pre>=MIN(IF(S22>0,S22,999999999999999),IF(W22>0,W 22,999999999999999),IF(AA22>0,AA22,999999999999999 ),IF(AE22>0,AE22,999999999999999))
</pre>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•