"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