# How to Assign Calculation Value

Calculation values are generally used for calculations. It represents the numerical value of an input field. This feature is only available in the following fields:

**🔘 Multiple Choice Field (Checkbox)**

**🔘 Single Choice Field (Radio Button)**

**🔘 Dropdown Field**

To assign calculation values on these fields, follow these steps:

1. Select the field on your form to highlight it then click the **GEAR** icon.

2. Go to the **OPTIONS** tab and toggle the **USE CALCULATION VALUES** option to **ON**.

3. Below that option will be a 2-column table showing all the options on the left and a corresponding blank column on the right. This is where you will type in the respective calculation values for each option.

You can either manually enter each calculation value per row or ** paste values** copied on your clipboard in the calculation values as a whole like so:

Instead of typing in 10, 20, 30, and 40 per row, you can paste...

**10**

**20**

**30**

**40**

...in one go. And that's it - The changes are automatically saved.

**NOTE:** For the **Dropdown Field**, the first option must always be ** zero**. This represents the first empty value of the Dropdown field.

Demo: https://www.jotform.com/43355144901955

Dropdown demo: https://www.jotform.com/60810099989975

### Send Comment

### 80 Comments...

See all comments## Related Forum Questions

- Trying to create a booking form with many behind the scenes calculations.
- Adding a Budget Form to Application Form
- Calculate the price of the stay and how many are in the room
- How can I set a calculation for my application form?
- How to create form calculation
- Run time constants. Feature request or bug report?
- Can I have a form field that does calculations?
- CALCULATED FIELDS!

HandmadeWithLove78I need help with this feature! I have sent a few messages and would like to start using this form. Can you please look at at my from and see why i am unable to see the numbers and calculations on my form please

jmclark634I have a product discounted lines included in the drop-down that are listed:

1. Buy 1 Get 1 half off

2. Buy 6 take 30% off order

3. Buy 12 items take 50% off order

How to calculate this under calculations value?

Thank you,

Ja'Von

LaurenThompsonI have multiple fields and wanted to know how you would get the online form ton provide a complete calculation at the end of a survey for example?

talk_enterprisesThis method does not bring up the $ symbol if instructions are followed.

FGOpsHow do I calculate the weight from pounds to kilos to grams?

khairi.khalidhow to set if i need for example on Monday 1st week and 2nd week at 9 am only 2 persons available can book the form. Because now i just setting for a day not a specific time for available person can book. Thank you

dengel72In order to have these calculatable in a spreadsheet integration, having each option cost with its own column in the sheet would be great, or alternately some sort of multi-sheet setup. F/E, I have a list of options but when using Sheets integration, the values aren't in the spreadsheet. My homebrew solution is to keep those items separately in a second sheet, but it means double-work and a double-place to change manage.

teamhigherThis is a great feature and very useful. I was hoping to use one of the widgets for a more stylish radio button, like "lined radio buttons" or "square radio buttons" but I see that none of those have an option for using calculation values. Am I missing something? or is there another way to add those values when using the widgets. I've tried all of the radio button widget types and none seem to have this option.

thanks

pvillanuevabCómo se hace para que aparezca el campo de abajo? el primero (el de arriba) ya complete los valores númericos de cada opción, la pregunta es cómo se hace para que aparezca el valor numérico de acuerdo a la elección realizada.

adebayostark123My Calculation values are not adding up its instead its just appending into numeric field e.g after clicking two options it results to "1,1" instead of two

Gary W MusslemanFor shipping I am wanting to use the USPS "flat rate" service. The items being shipped are videos tapes, which means different sizes. Here is my reality:

1 VHS = 3 VHS-C

1 VHS = 6 Mini DV

So there are basically three different sizes of tapes.

There are 4 different flat rate boxes.

Box A can hold 1 VHS

Box B can hold 6 VHS

Box C can hold 10 VHS

Box D can hold 15 VHS

If a person has a mixture of tape formats, I am wanting the form to be able to calculate which Biox is best for their shipping needs.

Any way to do this.?

Thanks in advance.

impactonmemphisHow do I get the $ to show in price field?

fanlowIs it possible to set the assigned calculation values as subscription plans? If so, what are the steps to go about it?

markbrennanfitnessWhen I paste a set of values to one single choice field, then paste another set of values to another single choice field, the FIRST single choice field updates to be the same as the SECOND.

STEMLab1Thank you this was helpful

YarraJFLhow do i make the form make the choice unavailable once a certain amount of people have chosen this field.

for example

Choose

check box AM

Check box PM

I want to close down the option to use "checkbox AM" once this box once 80 respondents have chosen

can you please help

how do i do this?

joelrtaub3939Very confusing to me. What I need instead of the field choice name showing up on a spread sheet down load, I just need a character, ie 1 to show up for each choice made. Can you show how to do this for a dummy?

joelrtaub3939I want a number 1 to be downloaded to my excel spreadsheet, so I tried to put a simple 2-1= that didn't work, tried to put a 1 value in but that didn't work either. What do I do?

TeamJOCHello!

We are trying to include a user supplied option so what value do we fill in the Calculation Values if we don’t know what it is. Is there something to fill in so it will pull the value from whatever our user enters?

wericksonIf the value of time in a date time field is between 8-5 I want "normal hours" auto selected in the next question, else "after hours" would be selected - how can I do that?

smartbizacademyHi,

i have to calculate "true" or "false" values by 33 questions

at the end, i have sum the proper values (sometimes True = 1, sometimes False = 1 etc) (I have a table)

how can i manage the calculations, pls?

VolACRSWhere do I find the calculation results after I set them? I've used the form calculator field, tried to add up all the items that I included but nothing has shown there. Form can be seen here: https://form.jotform.com/83315515964158

BlueGiraffeNo, I was talking about something else that I used once in my form.

It is a calculator that allows to summarize the chosen options.

For example if one class has been chosen, it is one price, if two classes have been marked, the double price appears automatically.

Thank you!

GoodtimeboysHow do I get this number to Multiply with another input?

Eg/

If I had one question asking how many items, then how do get it to multiply with another question which asks about price?

cvaughnHow can I get the calculated value to show in an excel report?

muscleblingIt is not totaling is there something I can do?

vmghr2I created this form to submit the right answers after the test is complete it is no longer doing that please help me get the form back on track to make things a little easier in our hiring process

lifeisawesomeI am trying to calculate results of multiple check boxes within each field (page) in for form calculation widget, but the final result is not showing properly. As a result, everything gets messed up. Kindly help.

https://www.jotform.com/build/81262216518453

patwardhanmaheshHi! Just wanted to know. How do we show calculation from numeric field values: I mean I have field1 and field2 and I want to show the result as field1/field2.

DRMIKE9327Hi,

I can't make this form total the answer values. https://form.jotform.com/81696920554163

dothanbyOK almost but when I select Classification type and enter a contributation amount is does not add then correctly try and you will see what I mean

andreia1991Olá,

Tenho uma lanchonete e quero criar um formulário para encomendas personalizada, onde o cliente seleciona os sabores e as quantidades de cada sabor, então no campo de múltipla escolha, ele precisa conseguir escolhar mais de uma opção, além de especificar a quantidade. por exemplo:

(x)Coxinha

Quantidade: 100

(x)Carne

Quantidade: 200

(x) Queijo

Quantidade: 160

etc.

Sabe me dizer como criar este tipo de formulário?

aubreybourkeApologies for the lack of response by the team. We tend to focus on questions in the forums or via email.

If you require a response you can rest assured that we will reply to all questions on the forums https://www.jotform.com/answers or via email support@jotform.com

ChristianLohmeier47 comments - no answers by the team - that's awesome... not

clayravinit's ok, I've worked out how to do it (see my question below) using the calculation widget

clayravinIs there a way for these calculation values be sent in the Notifcation email, instead of the option names?

Thanks.

SantosglassesNosotros necesitamos valor de calculo pero nuestros productos no se calculan por unidad , sino por metro cuadrado, (m2) por medida alto y ancho.

¿Se puede calcular?, si es asi digannos como por favor.

Gracias.

dayakanidhow to set the limit of the field and prevent same submission?

GrandraidcamarguePlease,

Is it possible to have this lesson in french ?

Thank you

Laurent GRENIER

ClaudiaMariaDesgualdoIs it possible to upload a pre formated chart with values and codes

soe2015How to show the "PRICE" field as the demo..?

ScoachNVM just got it to work, thanks!

ScoachPasting the values doesn't work - it just pastes all the values into the first option. Is there a specific way these are supposed to be written or just like you showed in one column?

I have them written out just like yours (please see below) and it's still not working.

10

20

30

40

SusanahbsmithI added calculation values for each of my multiple choice selections...now how do I make it so that my customers can see their total?

This is for a customer paying by check that does not need a payment form...

ScoachThis person's comment is EXACTLY WHAT I'M EXPERIENCING. Is there ANY way to revert to the old method?? PLEASE!! This really causes problem for my company's use of this form. ::

this update causes big problems when you have a long list. Before you could just copy and paste in one operation.

Now if you have a lot of options me and you edit the options list frequently it is a real nightmare since when you delete an option the value does not become deleted but shifted to the next option.

When you delete an item the values do not automatically associate correctly.

This is ridiculous and obviously released without consultation or bug checking.

REVERT TO OLD SYSTEM PLEASE

Sonny81This does not work on my form, anyone know why this maybe despite doing everything they have mentioned?

stevedellarthis update causes big problems when you have a long list. Before you could just copy and paste in one operation.

Now if you have a lot of options me and you edit the options list frequently it is a real nightmare since when you delete an option the value does not become deleted but shifted to the next option.

When you delete an item the values do not automatically associate correctly.

This is ridiculous and obviously released without consultation or bug checking.

REVERT TO OLD SYSTEM PLEASE

KickUpHi there,

Looks like the Calculation values got a facelift UI and it's now very difficult to update them... Is there any way to bulk copy what's already in there?

HPT765Hi there!

Am trying to emulate the form in the sample - I do not want a Next option - both panels on same page - tks

Chris_VMSGuys!

The new dropdown "add calculation value"style is REAL BAD! I'm unable to copy-paste entire rows of data from my spreadsheet! Having to do it one by one is impossible as I've a lot of data there!

Please revert to the old notepad style or better make a switch for two input styles to be used at our leisure.

Chris