Nesting mulptiple round functions

[Richard Ward]

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)*ROUND(VLOOKUP(A$21,CLASS,7,FALSE),2)*ROUND($E$2,2)*ROUND($E$9,2)+ROUND($B$5*VLOOKUP($G25,Territory,6,FALSE),2)*ROUND(VLOOKUP(A$21,CLASS,7,FALSE),2)*ROUND($E$2,2)*ROUND($E$15,2)*ROUND($E$9,2)

 

[iliace]

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(VLOOKUP(A$21,CLASS,
7,FALSE),2)*ROUND($E$2,2)*ROUND($E$15,2)*R­OUND($E$9,2),0)