maximum/minimum value in formula
 

Hey,

can someone help me with this issue.
i would like to add a minimum and maximum value to a excisting formula
example:
-value is 100 euros as result of a formula. and is also the maximum value(80
is the minimum value)
-this is value should never be more than 20(100euro)% or less than 10(80euro)%

hope this makes any sence...

thanks for your reply!

Best regards,
Tim.

maximum/minimum value in formula
 

Is this what you want

=MIN(MAX(your_existing_formula,80),100)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Tim G." <Tim wrote in message
...
Hey,

can someone help me with this issue.
i would like to add a minimum and maximum value to a excisting formula
example:
-value is 100 euros as result of a formula. and is also the maximum
value(80
is the minimum value)
-this is value should never be more than 20(100euro)% or less than
10(80euro)%

hope this makes any sence...

thanks for your reply!

Best regards,
Tim.

maximum/minimum value in formula
 

Or equivalently:

=MEDIAN(your_existing_formula,80,100)

Tim G. wrote:
Hey,

can someone help me with this issue.
i would like to add a minimum and maximum value to a excisting formula
example:
-value is 100 euros as result of a formula. and is also the maximum value(80
is the minimum value)
-this is value should never be more than 20(100euro)% or less than 10(80euro)%

hope this makes any sence...

thanks for your reply!

Best regards,
Tim.