Excel Problem, has this happened to you?

E

etriz1

I have a list of numbers that = 6960.23 in excel. However, when I take those
same numbers and add them with a calculator by hand, they = 6960.26. Why is
there a .03 cent difference?
 
S

Steve Dalton

Do you have negative numbers in the list and do you have the 'Precision as
Displayed' checkbox set?

Sounds like the error might be the sum of the undisplayed truncations.
 

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

Excel does not accept text format! 0
Autonumber field in Excel that behaves the same as Access 0
Turning off automatic calculation 0
Excell Otpions in office environment 0
Embed the same Excel multiple times 0
200KB versus 35MB 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0

Top