Subscribe Bookmark RSS Feed

Variable Level Ranges in Formulas

mcstagger

Community Trekker

Joined:

Oct 6, 2014

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...

  1. Poor
  2. Fair
  3. Good
  4. Very good
  5. 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!

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

How about

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

4 REPLIES
Solution

How about

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

mcstagger

Community Trekker

Joined:

Oct 6, 2014

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

Super User

Joined:

Jun 23, 2011

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

Community Trekker

Joined:

Oct 6, 2014

That is fantastic. Thank you!