Function to Truncate after Rounding?

[Guest]

I have created a report for our billing department that calculates dollar
amounts based on a calculation that has several decimal places. What they see
on the report is formatted as currency, and all the individual amounts jibe.
However, when they view the report's sum, it is sometimes off by a few cents
either way. And this is a big deal to the bean counters.

What is happening is that the calculations carry all the decimal places, not
the rounded currency versions of the numbers the users are seeing.

Is there a function I can insert in the calculation that will do the
rounding and then truncate all numbers after 2 decimal places, so that the
numbers the users see are the ones that are actually being summed?

Thanks!

 

[Guest]

Wrap all your calculations in the Round Function and specifiy 2 decimal places.

=Round(calculation here, 2)