nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Variable Level Ranges in Formulas

mcstagger

I am trying to use a range of levels from a source variable in a formula and encountering some challenges.

For example in TestVar I would have a response scale such as...

Poor
Fair
Good
Very good
Excellent

I want to use something like IF (TestVar == 1-3, "Rejector", "Acceptor")

"1-3" is treated as an equation which is not what I am looking for. Delimiting does not work either. I did get around this by simply recoding TestVar but I am thinking there has to be a way to use a range. I did consider an Or statement but I am curious if there is a way to use a range.

As always, thanks for the help!

Accepted answers

pmroz

How about

if (1 <= TestVar <= 3, "Rejector", "Acceptor")

All comments

pmroz

How about

if (1 <= TestVar <= 3, "Rejector", "Acceptor")

mcstagger

Thank you! That works perfectly and I would have never landed on that formatting for the parameter. Is there some documentation I can review within JMP or online that lays out that sort of logic for different scenarios?

pmroz

I found it in the scripting guide just the other day. In chapter 5 under operators. Look at table 5.3.

<=, < Less Equal Less a<=b<c Less Equal Less(a,b,c) Range check. Return 1 if true, 0 if false. Missing values in either a or b propagate missing values.

mcstagger

That is fantastic. Thank you!