# 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

### 65 Comments...

See all comments## Related Forum Questions

- Is there a way to calculate the price of the stay by using their dates and how many are in the room
- How can I set a calculation for my application form?
- How can I design beautiful interactive calculation 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!

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

andrewcoplonWhere can I see the final calculation value?

thaisprestonThis is not working on my form.

I have the values populated under properties > surveying but when I make my selections they don't output.

Do I need to add a field for them to output to? If so what element do i add.

marvinsombilonthis is not working

bbrettIs there anyway for the calculation to copy the exact value of the calculation value instead of rounding up?

e.g. I have a number 50.179 rounds up to 52.18, but I require it to be 52.179

lizianaola fiz tudo certinho coloquei os valores e não está funcionando.

no campo calculo nao aparece nada

oqmeasuresI'm looking to create values in which someone can choose three options for a price, with an additional 40 dollar charge for each item chosen after that. Can someone help me with that?

TalkNetHi, can I read the values in a spreadsheet from Google sheets instead of writing them in text form? So that they can be filled and modified automatically.

Similarly: can I link a form text to a cell in a Google sheet spreadsheet to show a result based on what is completed in the form?

Thank you

Hola, puedo leer los valores de una hoja de calculo de Google sheets en lugar de escribirlos en forma de texto? De modo que se puedan llenar y modificar automáticamente.

Del mismo modo: puedo vincular un texto del formulario a una celda de una hoja de calculo de Google sheet para mostrar un resultado en base a lo que se completo en el formulario?

Gracias

WaisthealthHow to add the quantity input option next to option

oloveszCan I add a decimal point in surveying. Forinstance if something is 1.50 How do I put that in surveying to collect that amount

chicudsI'm trying to display text instead of number values

e.g.

Drop Down list:

Auckland

Hamilton

Wellington

Values:

ACK

HAM

WEL

IS this possible?

mgregovI'm trying to figure out how this whole calculation stuff works. Can someone help me

committee_formsI have a gate access form where people enter their toll way card number. Tollway card has 8 digits eg. 12345678 but I only need last five. Is there a way where read only field recognize last 5 digits (45678) and fill it automatically? Thanks

Jaime63I do not understand what the "Calculation value" is. So if a person is voting on a choice of one and there are five choices, do I assign the calcuation value of "1" to each of the five?

clearview22How do I add a negative calculation value (ex. -30)?

DedydodianoHow to calculate the marks