Round Up/Down ?

G

Guest

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 !
 
T

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
 

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

Similar Threads

Copying formulas across columns 2
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2
how do I create a nonadjacent series for autofill to go by? 3
Formula Problem For Checkbook Register 1
IF Function 3
Date Formula 85 factor 7
Populate formula results in cells to next unique result. VBA or Fu 1
Ratio - How To Create Your Own Function/Formula 2

Top