Repair calculations from a pdf interactive form

Not all functions in Excel have a corresponding JavaScript method, but it is highly possible that the Excel function can be rewritten as function in Acrobat JavaScript and that function can be included with the form so anyone using the form with Acrobat Reader or Acrobat would have access the calculation without any other action like installing additional code.

Rounding can be controlled. Acrobat forms and one is able to separate the field value from the field's displayed value. One can see this by creating the calculation in more than one field, and then setting the format of one of the fields to "None" and observe the differences. One could even add a third field and use the "util.printf" method to force the value of a field to a rounded value. This approach does not use the default and simple calculation methods but requires the use of custom calculations and custom formatting to control the actual field value and the displayed values.

Acrobat and JavaScript provides several options for "rounding". There is JavaScripts Math.ceil and Math.floor methods that can either truncate a value to the next higher integer or to the closest lower integer. Also one could write a custom function to perform some other complex rounding.

It would help if you could post the formula that you use in Excel and the corresponding JavaScript in the PDF form. It could be the JavaScript could be improved/corrected.