How do I set up a Conditional Calc: < X and > OR = Y

Specifically, I have a calculation I need to perform:

IF Question response A < 7 and > or = 6, THEN set value of field B to 1.

I will be setting all these conditional calculations:

   IF A > 7, THEN set value of field B to 0

   IF A < 7 and > or = 6, THEN set value of field B to 1

   IF A < 6 and > or = 5, THEN set value of field B to 2

   IF A < 5, THEN set value of field B to 3

I set up condition 1 easily, but I am stuck on the following conditions.

Unfortunately this wont work as the conditions overlap. When they overlap they conflict and the outcome is unpredictable.

You should use ranges. For example:

If A > 0 and A < 3 = 1 and 2

if A > 2 and A < 5 = 3 and 4

etc

I'm sorry Aubrey, I don't understand your answer.

For example, in your response "If A > 0 and A < 3 = 1 and 2", I understand how to set up the condition (If A > 0 and A < 3), but I don't know what to do with (= 1 and 2).

Please give me more time to check the form you provided and test it further. I believe what my colleague said is that the condition you created is overlapping. 

I will contact you again on this thread once I have an update. Thank you.

Hi again,

Please check my demo form: https://form.jotform.com/80239442904961

In the demo form, I created field A and field B just for an example. You can clone the form to check my condition configuration. Is that what you're trying to achieve? 

If you have questions or need further assistance, please let us know.

Yes, that works John.

I set it to 

   IF A > 6.999, THEN set value of field B to 0

   IF A < 6.99 and > 5.999, THEN set value of field B to 1

   IF A < 5.99 and > 4.999, THEN set value of field B to 1

   ...etc

This does leave out 6.99 to 6.999, but fortunately that is extremely unlikely.

Feature Request: I would like a feature of the condition "Greater than or Equal to" to be added to the list of options.

You can try adding additional conditions to achieve the "Greater than or Equal to", here's an example:

If that is not okay with you, we can forward your feature request. 

We'll wait for your reply. Thank you.

That WILL work, but it would still be nice to have the other feature to reduce labor and complication.

One of 2 features would work:

 1) an option of "Greater than or Equal to" . For example, If "A" is > or = 1 and "A" is < 2, then C=  ...

  2) or being able to have "AND" and "OR" options in the same condition series.  For example, If "A" is > 1 and "A" is < 2, OR "A" = 1, then C=  ...

Thank you for the added information for the feature request.

I will forward the feature request to our developers. Please take note that we cannot provide you an ETA when this will be implemented but we will do our best to notify you once we have an update.

I hope this helps. Let us know if you need further assistance.