topic Re: How can I make 5>-1>=0.999 return the expected result of 0? in Discussions

How can I make 5>-1>=0.999 return the expected result of 0?

lehaofeng — Wed, 06 Sep 2023 09:23:27 GMT

Please ask a question: I was under the impression that JSL can be used to compare consecutively, for example: 5>-1>=0.999, but the running result is 1, what is the reason? Do I have to write 5>-1 & -1>=0.999?

Re: How can I make 5>-1>=0.999 return the expected result of 0?

jthi — Wed, 06 Sep 2023 09:57:41 GMT

Using JMP > Reference for JMP Functions in Formulas > Comparison Functions

So maybe swap it around

0.999 <= -1 < 5

Re: How can I make 5>-1>=0.999 return the expected result of 0?

lehaofeng — Thu, 07 Sep 2023 00:47:52 GMT

Thanks! Reading the help, I hadn't realised that the reverse wouldn't work.