• 462K Members
• 7,254 Online
• 559K Conversations

## Summing rounded dollar amounts.

Occasional Visitor

# 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?

Highlighted

# Re: Summing rounded dollar amounts.

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)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies