Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting Functions | Excel Worksheet Functions | |||
Help with Nesting two functions | Excel Discussion (Misc queries) | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Nesting Functions | Excel Worksheet Functions | |||
nesting 18 x functions | Excel Worksheet Functions |