Forum Discussion

TLFL_2019-'s avatar
TLFL_2019-
Copper Contributor
Apr 07, 2019

Summing rounded dollar amounts.

I am trying to find a way to sum dollar/cents amounts that were calculated as percentages of other amounts AND not end up with rounding errors (without having to manually type amount rounded to 2 places in a different cell).

 

Specifically, for example: I want to add 4% of a $26050.46 PLUS .25% of the same number. They have to be calculated and rounded separately and then I need the total of those two dollar amounts. 

$1042.02 + $65.13 = $1107.15

NOT

$ 1042.0184 + $ 65.12615 = $ 1107.14

 

Is that possible?

Formulas and Functions

2 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Apr 07, 2019
    If amount, 1st percentage, 2nd percentage, and total are in A2:D2, the formula in D2 is:
    =ROUND(A2*B2,2)+ROUND(A2*C2,2)
    • kevin_mcneil6659's avatar
      kevin_mcneil6659
      Copper Contributor
      Feb 19, 2022
      Thank you, I knew this had to be common and your suggestion worked perfectly. My calculated rounded dollar values are now being added as displayed and correctly summed for payroll purposes.