View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim G. Tim G. is offline
external usenet poster
 
Posts: 3
Default 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.