Hi Forum,
In an “If - Then”-action, I’m trying to get the following
If variable X is/isn’t “In the range between 1 - 1000”, then…
How do I to describe number-ranges, easier than 1|2|3|… etc.
Thanks and best,
A. P.
Hi Forum,
In an “If - Then”-action, I’m trying to get the following
If variable X is/isn’t “In the range between 1 - 1000”, then…
How do I to describe number-ranges, easier than 1|2|3|… etc.
Thanks and best,
A. P.
This macro should get you started.
Let us know if it works for you, or you have questions.
##Macro Library Determine if Variable is in Range
####DOWNLOAD:
<a class="attachment" href="/uploads/default/original/2X/5/53fc0ed0200a46c2c755a26ff45769449be081a0.kmmacros">Determine if Variable is in Range.kmmacros</a> (5.2 KB)
**Note: This Macro was uploaded in a DISABLED state. You must enable before it can be triggered.**
---
**Here's the Calculation Field**
`(DIV__X ≥ DIV__Range[1]) & (DIV__X ≤ DIV__Range[2])`
<img src="/uploads/default/original/2X/2/26d570f3ae9370341622ad4f7c10e67cc7417c84.png" width="469" height="1100">
Works like a charm! Thank you very much!
Best,
A. P.