I am trying to run a search for parts that have a characteristic value between two decimal values. It seems standard functionality for searching between to values requires whole numbers such as 1 to 10 using the “..” between operator. I have a need to search for values between say 0 to .03
When I enter that in I am getting a syntax error because my search looks like 0...03 which IFS is not recognizing the decimal in .03 as part of the number and rather part of the search operator.
Has anyone run into a similar need and what was your solution? It seems odd that IFS would not allow searching in a range of decimal values so is there another operator besides the “..” I should be using?
