hello there!
Recently I have been making some caculation with microsoft excel and I have noticed that it
multiplies numbers wrong...
http://img810.imageshack.us/img810/6378/stolj.jpg
Uploaded with ImageShack.us
for example.. I enter formula like this =H18*I18
and it should multiply 412 times 1,6 and total should be 659,2 and the computer shows: 658,88
??? I cant understand why this happening...
Are you sure the values 412 and/or 1600 are not formatted to display no decimal places?
i.e. what do you see in the formula bar if you click on the cells with 412 and 1,1600?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks