Read with Formatting | Join TechSpot! (it's free) | Bookmark / Share this



Excel can't add....

nickslick74
09-28-2007, 01:55 PM
Ok, it has a problem with a certain sum from multiplication, but who wants to see "Excel can't mulitply" as a title? Makes it sound like a bot!

http://www.msnbc.msn.com/id/21033161/

halo71
09-28-2007, 02:47 PM
That is pretty interesting! lol

Ad
09-28-2007, 02:47 PM

hynesy
09-30-2007, 06:21 AM
lol excel, funny how one specific multication causing problems.

Daveskater
09-30-2007, 09:04 AM
that's quite funny :D

i wanna try it haha

i just gave it a go and it came up with 100000
brilliant stuff

http://img216.imageshack.us/img216/1694/excelkc5.jpg

AlbertLionheart
10-01-2007, 03:33 PM
Now I know why I stuck with Lotus 123 all these years.

Daveskater
10-02-2007, 06:48 AM
i don't blame you ;) good ol' microsoft getting it right again

AlbertLionheart
10-02-2007, 07:50 AM
Just checked OpenOffice Calc - that works OK.
The more I think about this, the weirder it is - first that MS could let this go for so long - but also that it has taken someone so long to find it!

Daveskater
10-02-2007, 08:00 AM
the chances of someone finding this particular problem must be fairly low because it's such a random number and it involves multiplying decimals, unless it was just some sort of test

it's not often i need to get the number 65535 in my spreadsheets ;)

AlbertLionheart
10-02-2007, 08:12 AM
I googled it and found all sorts of stuff, including
"65535 is a frequently occurring number in the field of computing because it is the highest number which can be represented by an unsigned 16 bit binary number".
It is also a Mersenne number according to wiki.
Amazing!

Daveskater
10-02-2007, 08:33 AM
wow, turns out it's not as simple as it first seems

an innocent number turned into the highest unsigned 16 bit binary number

who'da thunk it?

Ad
10-02-2007, 08:33 AM

LuckyM
10-02-2007, 09:28 AM
i just wonder what will book-keepers do if companies they work for use excel...

 Top Technology News

 Software Downloads

Copyright © 1998-2008 TechSpot.com. TechSpot is a registered trademark. All Rights Reserved.