D_zeno

hi, does anyone knows how I can make a cell so that its value will have a maxium and minium.
example cell A2= 5*B2 minium 0,5 (so that if it gets lower it automatically becomes 0,5) maxium 135 (so that if it gets higher it automatically becomes 135)

Thank you already for the help

macropod

Hi D zeno,

Try:
=MIN(135,(MAX(0.5,5*B2))
or, for what I suspect you have for your regional settings:
=MIN(135;(MAX(0,5;5*B2))

D_zeno

thx for the response,
but that wasn't really what I wanted, i did it this way:
=IF(C19<5;5;IF(C19>9999;9999;ROUND(C19;0)))
minimum 5 and maximum 9999

macropod

Hi D zeno,

It's a bit hard to provide you with the solution you need when the question you ask has little to do with it.

There is no correspondence between what you asked for and what you now claim the solution to be, except that you want an arbitrary minumum and maximum. Your previous post had no mention of C19, a minimum of 5, a 9999 maximum or any rounding.

FWIW, you can do the same thing as your latest formula with:
=ROUND(MIN(9999;MAX(5;C19));0)
or
=MIN(9999;MAX(5;ROUND(C19;0)))

As you can see, not so very different from my previous solution.

D_zeno

oke thx very much