skip to main | skip to sidebar

Dwarf's blog

Wednesday, September 26, 2007

Bug in Excel 2007

Simply when you try to multiply 850 by 77.1 excel display the result to be 100000

Even Sumproduct returned 100000.
=SUMPRODUCT(850,77.1)
=SUMPRODUCT(850,77.1,2,0.5)
(2*0.5 = 1)

microsoft.public.excel
Posted by Dwarf at 2:33 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2007 (52)
    • ►  October (30)
    • ▼  September (17)
      • List of Free SEO Friendly Directories
      • The new Payment system company
      • Google AdSense for Mobile unlocks the potential of...
      • Google Supplemental Index Ratio Calculator
      • Bin Laden domain up for grabs
      • 1 US Dollar = 1 Canadian Dollar
      • Point Mugu Airshow 2007 F-22 Raptor
      • The Netscape social news experience that you are c...
      • Robots.txt Adventure
      • 40+ Free One-Column Website Templates
      • 50 Great Widgets For Your Blog
      • CSS TOOLBOX: 20+ Tools For Working With CSS
      • SEO Tools
      • FREE keyword suggestion tool
      • 1 GB IBM HDD 20 years ago
      • Free Web Hosting
      • Bug in Excel 2007
    • ►  February (5)

About Me

Dwarf
View my complete profile