In Between Two Values

Ask for Help
1

Hello,

I am trying to figure out if there is a way to check if a number is between two other numbers.

Screenshot 2023-11-03 at 8.43.29 PM
Screenshot 2023-11-03 at 8.43.29 PM448Ă—856 13.9 KB

In the screenshot above, as an example, I would like to check if a value is between 80 and 89, in the math rollup, and then print something out if the statement
is true.

Thank you

2

Use an if-then-else column:

  • If Number is greater than 89, then “not something”
  • If Number is less than 80, then “not something”
  • Else “something”
3 Likes
3

Hello,

I did try using the if-else-statments, however I am trying to organize them by the values. What that means is that all the 80-89 get one value while the 70-79 get another etc. The problem with the else is that is will associate all with that value.

4

That should be pretty easy to do with an IF column.

You would set up your IF column something like this.

IF number > 89 then X
ELSEIF number > 79 then Y
...
...
ELSE Z
2 Likes
5

Well, you didn’t say that earlier, did you?

As Jeff pointed out, you could still use an if-then-else column.

Another option would be a Query column. Take a look at the below video beginning at 4:40.

2 Likes