{"id":4653,"date":"2007-09-29T08:13:01","date_gmt":"2007-09-29T08:13:01","guid":{"rendered":"http:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/"},"modified":"2007-09-29T08:13:01","modified_gmt":"2007-09-29T08:13:01","slug":"excels-fuzzy-maths","status":"publish","type":"post","link":"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/","title":{"rendered":"Excel's fuzzy maths!"},"content":{"rendered":"\n<\/head>

The entire world uses Microsoft\u2019s Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug<\/a> and it cannot really do its maths right! <\/p>\n

\n

Microsoft Corp.\u2019s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.<\/p>\n

In a blog post, Microsoft employee David Gainer said that when computer users tried to get Excel 2007 to multiply some pairs of numbers and the result was 65,535, Excel would incorrectly display 100,000 as the answer.<\/p>\n

Gainer said Excel makes mistakes multiplying 77.1 by 850, 10.2 by 6,425 and 20.4 by 3,212.5, but the program appears to be able to handle 16,383.75 times 4.<\/p>\n

\"Further testing showed a similar phenomenon with 65,536 as well,\" Gainer wrote Tuesday.<\/p>\n<\/blockquote>\n<\/body><\/html>\n","protected":false},"excerpt":{"rendered":"

The entire world uses Microsoft’s Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug<\/a> and it cannot really do its maths right! <\/p>\n

\n

Microsoft Corp.’s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.<\/p>\n","protected":false},"author":1517,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[74],"tags":[],"class_list":["post-4653","post","type-post","status-publish","format-standard","hentry","category-technology"],"yoast_head":"\nExcel's fuzzy maths!<\/title>\n<meta name=\"description\" content=\"The entire world uses Microsoft's Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug and it cannot really do its maths right! Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel's fuzzy maths!\" \/>\n<meta property=\"og:description\" content=\"The entire world uses Microsoft's Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug and it cannot really do its maths right! Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/\" \/>\n<meta property=\"og:site_name\" content=\"Drishtikone\" \/>\n<meta property=\"article:published_time\" content=\"2007-09-29T08:13:01+00:00\" \/>\n<meta name=\"author\" content=\"Desh Kapoor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Desh Kapoor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/\",\"url\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/\",\"name\":\"Excel's fuzzy maths!\",\"isPartOf\":{\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/#website\"},\"datePublished\":\"2007-09-29T08:13:01+00:00\",\"dateModified\":\"2007-09-29T08:13:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/#\/schema\/person\/e24bcebf9da3425dd595b71543245311\"},\"description\":\"The entire world uses Microsoft's Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug and it cannot really do its maths right! Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel's fuzzy maths!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/#website\",\"url\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/\",\"name\":\"Drishtikone\",\"description\":\"Perspective on Life and World from Hindu and Indian standpoints\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/#\/schema\/person\/e24bcebf9da3425dd595b71543245311\",\"name\":\"Desh Kapoor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cc132f0b1d11236e6dc28b12e598a23?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cc132f0b1d11236e6dc28b12e598a23?s=96&d=mm&r=g\",\"caption\":\"Desh Kapoor\"},\"description\":\"Making sense of the world via the perspective of Dharma and Hinduism. Drishtikone literally means \\\"View from an Angle\\\" in Hindi. It is a word used for \\\"Perspective\\\" in Hindi conversations.\",\"url\":\"https:\/\/www.patheos.com\/blogs\/drishtikone\/author\/drishtikone\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel's fuzzy maths!","description":"The entire world uses Microsoft's Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug and it cannot really do its maths right! Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/","og_locale":"en_US","og_type":"article","og_title":"Excel's fuzzy maths!","og_description":"The entire world uses Microsoft's Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug and it cannot really do its maths right! Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.","og_url":"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/","og_site_name":"Drishtikone","article_published_time":"2007-09-29T08:13:01+00:00","author":"Desh Kapoor","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Desh Kapoor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/","url":"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/","name":"Excel's fuzzy maths!","isPartOf":{"@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/#website"},"datePublished":"2007-09-29T08:13:01+00:00","dateModified":"2007-09-29T08:13:01+00:00","author":{"@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/#\/schema\/person\/e24bcebf9da3425dd595b71543245311"},"description":"The entire world uses Microsoft's Excel to do its maths on computer! Entire Planning and Forecasting systems of even the largest of the world corporations are built on Excel with all the complex algorithms. What if that foundation has a bug such that it cannot do a simple math? Well that is how it is! Excel has a bug and it cannot really do its maths right! Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.","breadcrumb":{"@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/2007\/09\/excels-fuzzy-maths\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.patheos.com\/blogs\/drishtikone\/"},{"@type":"ListItem","position":2,"name":"Excel's fuzzy maths!"}]},{"@type":"WebSite","@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/#website","url":"https:\/\/www.patheos.com\/blogs\/drishtikone\/","name":"Drishtikone","description":"Perspective on Life and World from Hindu and Indian standpoints","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.patheos.com\/blogs\/drishtikone\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/#\/schema\/person\/e24bcebf9da3425dd595b71543245311","name":"Desh Kapoor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.patheos.com\/blogs\/drishtikone\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cc132f0b1d11236e6dc28b12e598a23?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cc132f0b1d11236e6dc28b12e598a23?s=96&d=mm&r=g","caption":"Desh Kapoor"},"description":"Making sense of the world via the perspective of Dharma and Hinduism. Drishtikone literally means \"View from an Angle\" in Hindi. It is a word used for \"Perspective\" in Hindi conversations.","url":"https:\/\/www.patheos.com\/blogs\/drishtikone\/author\/drishtikone\/"}]}},"_links":{"self":[{"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/posts\/4653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/users\/1517"}],"replies":[{"embeddable":true,"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/comments?post=4653"}],"version-history":[{"count":0,"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/posts\/4653\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/media?parent=4653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/categories?post=4653"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.patheos.com\/blogs\/drishtikone\/wp-json\/wp\/v2\/tags?post=4653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}