You could calculate the total commission using the revenue details

=SUMPRODUCT(rev_range*5%)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JT" wrote in message
...
We're preparing a report and the detail commission values are rounded to
two
decimals. I also calculate commission as Total Revenue x 5% (rounded to
two
decimals). The problem is the sum of the rounded detail values does not
equal the Total Revenue x 5% value.

For example:

Total Revenue = $117,524.11 and the Commission = $5,876.21 (5%).

However, when multiplying the row-level detail by 5% and rounding to two
places and then summing the column I get $5,876.71, a $0.50 increase.

Is there anyway to add the rounded values at the detail level so that it
equals the Total Revenue x 5% or am I trying to mix apples and organes?

Thanks for the help.........

--
JT