13442_en-US

liliconcom

Variable Level Ranges in Formulas<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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!

Re: Variable Level Ranges in Formulas

That is fantastic. Thank you!

Re: Variable Level Ranges in Formulas

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.

Re: Variable Level Ranges in Formulas

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?

Re: Variable Level Ranges in Formulas

How about

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