JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to check if a value is in between two values?Asked by jfullwiler2 on April 25, 2016 at 08:22 AM
Seems like and easy question, but I am wondering if form calculation can perform If "between" values.
For example: If I need to calculate less than 100 pounds, between 100-200 pounds and greater than 200 pounds.
<100=Light; 100～200=Medium; >200=Heavy
"less than" and "greater than" are easy to figure out but I can't seem to figure out the "between" calculation.
We do not have a direct method to check if the value in between. However, it is possible to create conditions to check if the entered value is in between two values. Please see the following conditions that I used to check if the entered value is in between 100 and 200. I've not included 100 and 200 to check in the conditions.
Please check the demo form below:
Please feel free to clone the form to see how the conditions are set.
Hope this information helps! If you need any further assistance, please let us know. We will be happy to help.