| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
| VBA Question | Excel Discussion (Misc queries) | |||
| Question | Excel Worksheet Functions | |||
Linear Mode
