Summing rounded dollar amounts.

%3CLINGO-SUB%20id%3D%22lingo-sub-401481%22%20slang%3D%22en-US%22%3ESumming%20rounded%20dollar%20amounts.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401481%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20find%20a%20way%20to%20sum%20dollar%2Fcents%20amounts%20that%20were%20calculated%20as%20percentages%20of%20other%20amounts%20AND%20not%20end%20up%20with%20rounding%20errors%20(without%20having%20to%20manually%20type%20amount%20rounded%20to%202%20places%20in%20a%20different%20cell).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESpecifically%2C%20for%20example%3A%20I%20want%20to%20add%204%25%20of%20a%20%2426050.46%20PLUS%20.25%25%20of%20the%20same%20number.%20They%20have%20to%20be%20calculated%20and%20rounded%20separately%20and%20then%20I%20need%20the%20total%20of%20those%20two%20dollar%20amounts.%26nbsp%3B%3C%2FP%3E%3CP%3E%241042.02%20%2B%20%2465.13%20%3D%20%241107.15%3C%2FP%3E%3CP%3ENOT%3C%2FP%3E%3CP%3E%24%201042.0184%20%2B%20%24%2065.12615%20%3D%20%24%201107.14%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401481%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-401497%22%20slang%3D%22en-US%22%3ERe%3A%20Summing%20rounded%20dollar%20amounts.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401497%22%20slang%3D%22en-US%22%3EIf%20amount%2C%201st%20percentage%2C%202nd%20percentage%2C%20and%20total%20are%20in%20A2%3AD2%2C%20the%20formula%20in%20D2%20is%3A%3CBR%20%2F%3E%3DROUND(A2*B2%2C2)%2BROUND(A2*C2%2C2)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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?

1 Reply
Highlighted
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)