Excel not calculating like my calculator - needs to round or not round

[lastingimprint02]

On my calculator, if I divide 462,534.05 by 335 I get 1,380.70. Then if I times 1,380.70 by 335 I get 462,534.50. Which is what I need it to be because I need to calculate the difference of a figure not dividing equally.

On excel, if I divide 462,534.05 by 335 I get 1,380.70. Then if I times 1,380.70 by 335 I get the SAME result of 462,534.05.

I have to account for the difference of not dividing equally so there is some format or accounting function that's preset that I don't want but I have no idea how to fix it or format my excel sheet to calculate as my calculator would.

Please can someone help? Thanks!

 

[shg]

On excel, if I divide 462,534.05 by 335 I get 1,380.70.

No, you get 1380.69865671642, which you may have displayed as 1,380.70.

Then if I times 1,380.70 by 335 I get the SAME result of 462,534.05.

That's because it's using the full precision of the result above. And that's what you'd expect, is it not?

 

[AlphaFrog]

Set this option in Excel...

Excel 2007 or later:
Precision as displayed

Excel 2003 or before:
From the Excel menu, select Tools\ Options
Select the "Calculation" tab
Check the "Precision as Displayed" checkbox

 

[lastingimprint02]

AlphaFrog - that option for 2007 is exactly what I was looking for thanks!