Advanced Help : DMIN function

Posted by deadlee on February 05, 2002 7:22 AM

Hey Guys,

I'm trying to find the lowest value in a particular ROW, based on certain criteria.

I've tried using the DMIN function, and it works beautifully, except that it works only for COLUMNS. I wanna use ROWS.

Ne suggestions?

Here's an example

Rates 0.00 1.12 1.63 1. 09 4.98 2.3

I want to find the lowest non-zero rate, wh ich would be 1.09.
How Should I Do that?

All Help Much Appreciated

Posted by Mark W. on February 05, 2002 7:41 AM

{=MIN(IF(Rates,Rates))}

where 'Rates' is the cell range containing rates.

Note: This is an array formula which must be
entered using the Control+Shift+Enter key
combination. The outermost braces, {}, are not
entered by you -- they're supplied by Excel in
recognition of a properly entered array formula.

Posted by Raoul on February 05, 2002 8:29 AM

How does that IF statement work Mark W??

I'm trying to improve my Excelling by reading through some of these tips, but I just don't get the conditions used in this IF statement, would you mind explaining please. I'm wondering whether the IF works differently within an array??

Cheers
Raoul {=MIN(IF(Rates,Rates))} where 'Rates' is the cell range containing rates. Note: This is an array formula which must be

IF() accepts 3 arguments... a condition, a return
value is true, and a return value if false. If
either return value isn't specified IF() returns
the condition results as a boolean (TRUE or FALSE)
value. IF()'s condition can also be a number
where 0 is FALSE and all others are TRUE. So,
{=IF({1,0,-3},"Yeah, baby!")} will return...

{"Yeah, baby!",FALSE,"Yeah, baby!"}

Posted by Mark W. on February 05, 2002 8:39 AM

Re: How does that IF statement work Mark W??

Posted by Aladin Akyurek on February 05, 2002 8:53 AM

Have a look at

20019.html

The OP might be asking for non-neg min.

Posted by Raoul on February 05, 2002 9:45 AM

Thanks to you both - that's quite cool

The OP might be asking for non-neg min.