I'm using the following calculation to add up invoice fields.

zUnit Price Calc + zUnit Price 2 Calc + Unit Price 3 Calc + Unit Price 4 Calc +Unit Price 5 Calc + Unit Price 6 Calc + Unit Price 7 Calc + Unit Price 8 Calc + Unit Price 9 Calc + Unit Price 10 Calc + Unit Price 12 Calc + zUnit Price Custom Charges Calc + zUnit Price Metal Calc + zUnit Price Body Trim Calc + zUnit Price Nail Calc + zUnit Price Panel Calc + zUnit Price Stone Calc + zUnit Price Wood Calc + zUnit Price Base Calc

It is totaling $1266.67. Manually it add up to $1266.65 which is correct. Any suggestions on how to make my total accurate?

Thank you

Computers generate some long decimal numbers.

Years ago I found that Excel suffered from extraneous numbers in the 12+ decimal places, for instance.

Use the Round() or Truncate(?) functions to eliminate these extraneous decimals.

For instance, to get the value of a particular item you might use a calc that divides or one that uses a longer decimal such as 1.56784.

Example zUnit Price Calc = Round( (Length x Cost per foot x something) ; 2 )

With the round the result might be 125.36 but without it 125.36225

Those .00225's can add up and create those differences.

You may not see these extra digits when you format your fields for decimal with 2 places.