Forum Discussion
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 pla...
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)
=ROUND(A2*B2,2)+ROUND(A2*C2,2)
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.