Need Help: DC constrain min/max scaling size

derei

I want to scale a DC within two limits (min:5cm / max:500cm), but I can't figure how to constrain to both.
To constrain for one of them I can use "if" condition, but I have no idea how to use for both ends constraining.

Thanks.

EDIT
Thanks Box for pointing out the error in this post, I corrected it now. It was meant to be 5CM (but I am sure you figured it out, even if it was wrong).
Would you be so kind to offer a solution for my problem, now?

danielbowring

If you want to avoid if statements, you can use SMALLEST and LARGEST like so

=SMALLEST(MAX_VALUE, LARGEST(MIN_VALUE, value))

pcmoor

Hi

using the conditional statement is correct,(<5) then smallest (current & 50)
note for metric you have to use 2.54 as a conversion from inches to cm when getting or using the current value

example attached
Philip

5min.skp

derei

@pcmoor said:

Hi

example attached
Philip

Please for SU8, thank you!

pcmoor

No worries....

SU8