Nesting mulptiple round functions
 

I have a complex formula that needs to be rounded to 2 decimal places until
the final calculation when the round needs to be 0. When I change the final
round from 0 to 2, I get a completely different result.

=ROUND($B$4*VLOOKUP($G25,Territory,5,FALSE),2)*ROU ND(VLOOKUP(A$21,CLASS,7,FALSE),2)*ROUND($E$2,2)*RO UND($E$9,2)+ROUND($B$5*VLOOKUP($G25,Territory,6,FA LSE),2)*ROUND(VLOOKUP(A$21,CLASS,7,FALSE),2)*ROUND ($E$2,2)*ROUND($E$15,2)*ROUND($E$9,2)

Nesting mulptiple round functions
 

I'm not seeing the final round; all those are on the same level. You
can try this:

=ROUND(ROUND($B$4*VLOOKUP($G25,Territory,5,FALSE), 2)*ROUND(VLOOKUP(A
$21,CLASS,7,F*ALSE),2)*ROUND($E$2,2)*ROUND($E$9,2) +ROUND($B
$5*VLOOKUP($G25,Territory,6,FA*LSE),2)*ROUND(VLOOK UP(A$21,CLASS,
7,FALSE),2)*ROUND($E$2,2)*ROUND($E$15,2)*R*OUND($E $9,2),0)


On Sep 4, 3:14 pm, Richard Ward
wrote:
I have a complex formula that needs to be rounded to 2 decimal places until
the final calculation when the round needs to be 0. When I change the final
round from 0 to 2, I get a completely different result.

=ROUND($B$4*VLOOKUP($G25,Territory,5,FALSE),2)*ROU ND(VLOOKUP(A$21,CLASS,7,F*ALSE),2)*ROUND($E$2,2)*R OUND($E$9,2)+ROUND($B$5*VLOOKUP($G25,Territory,6,F A*LSE),2)*ROUND(VLOOKUP(A$21,CLASS,7,FALSE),2)*ROU ND($E$2,2)*ROUND($E$15,2)*R*OUND($E$9,2)