Round Up/Down ?

[TQ]

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 !

 

[Trevor Shuttleworth]

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

 

[MartinW]

Hi TQ,

Have a look here, slightly different problem, but
still the same underlying problem.

http://www.mcgimpsey.com/excel/pennyoff.html

HTH
Martin