Another question
 

Hello all,

I have another question.

How to have the minimum value of a column that not includes the 0.
I´m trying MIN(B5:B10)... but, the formula returns the 0.

Well, thanks for your attention.

P.S. By the way, thanks for all the good answers.

Another question
 

You can do as follows:

=IF(MIN(IF(B5:B10<0,B5:B10))=0, "No minimum value to display",
MIN(IF(B5:B10<0,B5:B10)))

Press CTRL+SHIFT+ENTER when you finish.

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/

Another question
 

Hi Robert,

Thank you for the answer.
But i´m not making this work. Is there any other way?
Thanks

"jimmy" wrote:

Hello all,

I have another question.

How to have the minimum value of a column that not includes the 0.
I´m trying MIN(B5:B10)... but, the formula returns the 0.

Well, thanks for your attention.

P.S. By the way, thanks for all the good answers.

Another question
 

On Fri, 9 May 2008 05:20:01 -0700, jimmy
wrote:

Hello all,

I have another question.

How to have the minimum value of a column that not includes the 0.
I´m trying MIN(B5:B10)... but, the formula returns the 0.

Well, thanks for your attention.

P.S. By the way, thanks for all the good answers.

Array-enter this formula:

=MIN(IF(B5:B10<0,B5:B10))

To array-enter a formula, hold down <ctrl<shift while hitting <enter. Excel
will place braces {...} around the formula
--ron

Another question
 

Jimmy

WHen you type the last parenthesis you will need to press (all together) the
keys CTRL+SHIFT+ENTER instead of ENTER alone...

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/