LinkBack URL
About LinkBacks
I've calculated this about 10 times but there is something very very wrong here.
When I make the sum of column J manually, I get 1131 while Excel feels it should be 1130. Is this a computer error or am I going mad
I've calculated this about 10 times but there is something very very wrong here.
When I make the sum of column J manually, I get 1131 while Excel feels it should be 1130. Is this a computer error or am I going mad
Please FORMAT CELLS of column J as number with two decimal places. You will see that these numbers are not rounded.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Format numbers with more deicmal places and you'll see those number are rounded. Now try to sumarise number with 3 decimapl places and see is there any difference and let us know
Never use Merged Cells in Excel
I hope I've understood correctly but I still can't see what's wrong (it seems to round up just fine). New formatting attached
Last edited by Jeroen1000; 10-19-2009 at 05:40 AM.
You just like to tortch us
1129,959
And excel said 1129,958
Now take more dicimal places and you'll get more correct solution (because of those divided by 3 and 6 numbers)
Ow I was looking at it the wrong way. Feel free to hurl a brick now, lol. in my defense I am dyslectic so it's a real torture
That the reason I don't use decimals most of the time. Doesn't always work out
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks