How to check if a value is in between two values?

  • jfullwiler2
    Asked on April 25, 2016 at 8:22 AM

    Hello,

      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.

     

    Thanks!

  • Kiran Support Team Lead
    Replied on April 25, 2016 at 9:52 AM

    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.

    How to check if a value is in between two values? Image 1 Screenshot 20

    Please check the demo form below:

    https://form.jotform.com/61154333168957

    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.