Does anyone have a simple way to determine if a value is between two others?
Example

Act# Balance
1 100
2 200
3 300
4 400

Want to know which ones are more than 100 but less than 400.