
Creator
2022-02-23
10:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Find whether a value is between two numbers
Hello
I imagine this is quite simple but I'm struggling to find the answer. Essentially I'm trying to find a 'between' function. So I want to say:
If row1.MY_COLUMN is between 500000 and 610000 then use that value, else 'something else'..
Tia for any help!
527 Views
1 Solution
Accepted Solutions

Anonymous
Not applicable
2022-02-23
10:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
row1.MYCOLUMN >=500000 && row1.MYCOLUMN <=610000 ? row1.MYCOLUMN : -1
This is an in-line IF. It says, "IF MYCOLUMN is greater than or equal to 500000 and MYCOLUMN is less than or equal to 610000, then use MYCOLUMN, else use -1".
527 Views
2 Replies

Anonymous
Not applicable
2022-02-23
10:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
row1.MYCOLUMN >=500000 && row1.MYCOLUMN <=610000 ? row1.MYCOLUMN : -1
This is an in-line IF. It says, "IF MYCOLUMN is greater than or equal to 500000 and MYCOLUMN is less than or equal to 610000, then use MYCOLUMN, else use -1".
528 Views

Creator
2022-02-23
11:13 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Works perfectly, thank you! 🙂
527 Views
