Nesting mulptiple round functions

R

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)
 
I

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top