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

  • Profile Image
    Asked 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.



  • Profile Image
    Answered on April 25, 2016 at 09: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.

    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.