"I want to round a field answer to two decimal places, reducing the accuracy of the number, how would I do that? I have a special entry that will calculate depending on a couple criteria that the user provides, but the number always goes past two decimal places, can someone help me?"

Question

&quot;I want to round a field answer to two decimal places, reducing the accuracy of the number, how would I do that? I have a special entry that will calculate depending on a couple criteria that the user provides, but the number always goes past two decimal places, can someone help me?&quot;

Vipin · Accepted Answer

You can use the ROUND function to round the answer to the nearest integer or decimals.

Use ROUND( existing formula ) to round to 2 decimal places.
Use ROUND( existing formula, 0 ) to round to the nearest integer.

Jeremiah Liverseidge · Answer

so it would just be 'ROUND(@blah..)'???

Vipin · Answer

Let's say A, B, and C are fields you’ve added to the form. If you want to calculate C as the value of A × B and round it to two decimal places, you should use ROUND(A * B) in the Calculate option for field C. Please note that you’ll need to type @ in the Calculate option and select fields A and B from the list to include them in the formula.

Guesswork

I want to round a field answer to two decimal places, reducing the accuracy of the number, how would I do that? I have a special entry that will calculate depending on a couple criteria that the user provides, but the number always goes past two decimal places, can someone help me?

Comments (3)

Add your comment

I want to round a field answer to two decimal places, reducing the accuracy of the number, how would I do that? I have a special entry that will calculate depending on a couple criteria that the user provides, but the number always goes past two decimal places, can someone help me?

Comments (3)

Add your comment

Related questions