Calculation questions: greater than, less than, is not greater than

Question & Answer
, , ,
1

Hello,
Im trying to make a calculation to get a value based on if X >60 AND X <80 AND X IS NOT <60 AND X IS NOT > 80, but when I put the NOT I get error, can someone guide me on how to do this?

2

surely “if X >60 AND X <80” is the exact same as:
“if X IS NOT <60 AND X IS NOT > 80” therefore it is getting confused and displays an error?

I could be wrong.

If you send a screenshot for more context / what you are putting in and what you are getting (error message), it would be easier to solve.

3

Hello @aquintanilla,

To use NOT on the calcluation you need to include it in front of a boolean, so your logic will be something like this.

X>60 AND X<80 AND NOT (X<60) AND NOT (X>80)

Hope this helps!