Conditional Minimum value

  • Thread starter Thread starter mooiw000
  • Start date Start date
M

mooiw000

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
 
=min(if(A1:A200>10,A1:A200))
Entered with Ctrl+Shift+Enter rather than just enter since this is an array
formula.
 
mooiw000 said:
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
Click to expand...


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
 
Back
Top