Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Up/Down ?
Hi,question as below
B2=3.6 C2=2440 D2=1220 E2=1700 G2=$667.00 F2=18.2180(from formula=B2/1000*C2/1000*D2/1000*E2) I get the figure $12,151.42 from G2*F2.According to calculator $667.00 * 18.2180 should get $12,151.41. Is that any solution to solve the different ?I want it get exactly same with calculator and using by formula to get F2 figure. Thanks ! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Up/Down ?
F2 is actually 18.218016
The result is: 12151.416672 On my calculator, if I multiply 18.218016 by 667, I get 12151.416 but it only displays 8 digits. I'm surprised that my calculator appears to have truncated rather than rounded up but there you go. Looks like Excel got the calculation right. You need to put more decimal places into the calculator if you want to compare the output. Regards Trevor "TQ" wrote in message ... Hi,question as below B2=3.6 C2=2440 D2=1220 E2=1700 G2=$667.00 F2=18.2180(from formula=B2/1000*C2/1000*D2/1000*E2) I get the figure $12,151.42 from G2*F2.According to calculator $667.00 * 18.2180 should get $12,151.41. Is that any solution to solve the different ?I want it get exactly same with calculator and using by formula to get F2 figure. Thanks ! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round Up/Down ?
Hi TQ,
Have a look here, slightly different problem, but still the same underlying problem. http://www.mcgimpsey.com/excel/pennyoff.html HTH Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round time maybe this explanation will help | Excel Discussion (Misc queries) | |||
ROUND or "Precision as displayed"? | Excel Worksheet Functions | |||
Round a number in nested function | Excel Worksheet Functions | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
How to make a number round up/down to a set number | Excel Worksheet Functions |