TechSpot

Excel can't add....

By nickslick74
Sep 28, 2007
  1. 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/
     
  2. halo71

    halo71 TS Rookie Posts: 1,090

    That is pretty interesting! lol
     
  3. hynesy

    hynesy TS Maniac Posts: 389

    lol excel, funny how one specific multication causing problems.
     
  4. Daveskater

    Daveskater Banned Posts: 1,687

    that's quite funny :D

    i wanna try it haha

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

    [​IMG]
     
  5. AlbertLionheart

    AlbertLionheart TechSpot Chancellor Posts: 2,026

    Now I know why I stuck with Lotus 123 all these years.
     
  6. Daveskater

    Daveskater Banned Posts: 1,687

    i don't blame you ;) good ol' microsoft getting it right again
     
  7. AlbertLionheart

    AlbertLionheart TechSpot Chancellor Posts: 2,026

    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!
     
  8. Daveskater

    Daveskater Banned Posts: 1,687

    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 ;)
     
  9. AlbertLionheart

    AlbertLionheart TechSpot Chancellor Posts: 2,026

    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!
     
  10. Daveskater

    Daveskater Banned Posts: 1,687

    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?
     
  11. LuckyM

    LuckyM Banned Posts: 66

    i just wonder what will book-keepers do if companies they work for use excel...
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...