Setting an interval in expression.

Question

I want to write a formular that can select the number in a specific interval. for example, I want to use fulter tool to pick 2,3, and 4.

If I use 【n IN (2,4)】, then I can only get 2 and 4. Can I use a simgle expression to do this job？

PanPP · Answer

That wouldn't be a valid expression within the Filter tool.

Mike11Lee · Answer

Thanks to reply, I wonder if there exist a shorter expression, such as 2 <= [n] <= 4 (I have tried this expression, didn't work) that only need one [n].

PanPP · Answer

Hi @Mike11Lee

I have uploaded a sample WF that uses a filter tool to get values 2-4.

Sample WF - Range.yxmd