How can I add a calculation to my form that is based on multiple parameters?

I'm trying to create a form that will calculate shipping weight and dimensions according to specific parameters (see screenshot).  

The user inputs net weight and quantity (among other things) and I want there to be an output that shows dimensions and tare (gross weight). How would I go about putting these calculations into my form?

Hi,

Calculations in your form can be achieved by using the form calculations widget:

http://widgets.jotform.com/widget/calculation

Here is our guide on on using and setting up this widget:

http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

You would need to assign calculation values to each field and then setup the equation you desire.  The result will be displayed in the calculation widget field.

There are also several other calculation widgets that may be able to accomplish what you are looking for:

http://widgets.jotform.com/category/calculation

Though the one I first posted has the easiest functionality.

If this is not what you were looking for, please let us know and we will be happy to see what else we can do.

Hi David,

Thank you for your response.  I'm still having trouble adding calculations to this form, because I need to add logical functions (like Excel IF functions). Is there any JotForm calculation widget capable of doing logical test functions?

Thanks,
Nick

Form calculation has included some more complex Mathematical operations:

But you can also use conditions to update fields:

You can test and clone the demo form:

http://form.jotformpro.com/form/50075991693970

Let us know if you need further support.

How do I make it so:

(gross weight) field (is less than or equal to)


I need a nested IF function, which would look like this:

=IF (gross weight is less than or equal to 10, output 1.77) OR (gross weight is less than or equal to 30 but more than 10, output 5.31) and so on

Here's the formula from Excel which is calculating tare based on gross weight (M6):

=IF(M6<=10,1.77,IF(M6<=30,5.31,IF(M6<=50,8.85,IF(M6<=130,17.7,IF(M6<=200,15.3,IF(M6>200,M6/200*15.3))))))

I'm not sure if it is possible to achieve this but I will run further tests and will get back to you once I have more details.

Let us know if we can assist you further.

If I understood you right there are 6 different fixed outputs. If this is correct, I chose a simpler solution that is using a dropdown field where user will select one of 6 weight categories. And according to the selection it will update a form field with a specific value.

You can test and clone the demo form: 

http://form.jotformpro.com/form/50147376047960? 

The conditions I added to this form was update a form field value:

Let us know if this is a solution for you.