How to add excel formula with round up 50 into jotform?

Hi,

I have formula in excel sheet which is having round up 50 value.How to add this formula in jotform

https://prnt.sc/5PnongOk_EmD ?

https://form.jotform.com/241080127602444

Currently added formula like this https://prnt.sc/vRbdBvz63deT but values of output getting different as compared to excel sheet values.

We need to round up value upto 50

Hi Judy,

Thanks for contacting Jotform Support. Unfortunately, it is not possible to import an Excel file with its formula into a form. What you could do is use the Spreadsheet widget where you can create calculations if you want to.

You may also use our Advanced Formula in Tables as an alternative:

I also suggest taking a look at the following guides that might help you:

• How to Perform Form Calculation Using a Widget
• Import App: Easily Import Your Excel or CSV Data into Jotform

You can use our spreadsheet to form widget to populate customer's name and address. Check out this guide on How to Use the Spreadsheet to Form Widget

Give it a try and reach out again if you have any other questions.