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