Hi,

Can somebody help me with a conditional minimum value function. I a
looking for a function that will help me establish minimum value, abov
a certain threshold. similar to sumif or countif but than a minif

all suggestions greatly appreciated.

Eri

--
mooiw00
-----------------------------------------------------------------------
mooiw000's Profile: http://www.excelforum.com/member.php...fo&userid=3780
View this thread: http://www.excelforum.com/showthread.php?threadid=57371

=min(if(A1:A20010,A1:A200))
Entered with Ctrl+Shift+Enter rather than just enter since this is an array
formula.

--
Regards,
Tom Ogilvy


"mooiw000" wrote:


Hi,

Can somebody help me with a conditional minimum value function. I am
looking for a function that will help me establish minimum value, above
a certain threshold. similar to sumif or countif but than a minif

all suggestions greatly appreciated.

Eric


--
mooiw000
------------------------------------------------------------------------
mooiw000's Profile: http://www.excelforum.com/member.php...o&userid=37809
View this thread: http://www.excelforum.com/showthread...hreadid=573718

"mooiw000" wrote in
message ...

Hi,

Can somebody help me with a conditional minimum value function. I am
looking for a function that will help me establish minimum value, above
a certain threshold. similar to sumif or countif but than a minif

all suggestions greatly appreciated.

Eric



Consider the MAX fuction.
Example: Put following code into A2: =MAX(A1,100)
Result: No matter what value A1 assumes, A2 will display at least 100.
Is that what you were looking for?

Joerg