Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.<\/p>\n
<\/iframe><\/p>\n<p>You can view part two in this series\u00a0<a href=\"http:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-bug-workaround\/\">Microsoft Excel Bug Workarounds<\/a><\/p>\n<p>For more information about the bug please read\u00a0<a href=\"http:\/\/www.itguaranteed.com.au\/blog\/index.php\/microsoft-excel-addition-error\/\">Microsoft Excel Addition Bug<\/a><\/p>\n<p>Visit\u00a0<a href=\"http:\/\/www.itguaranteed.com.au\/blog\/index.php\/the-making-of-the-excel-bug-guy-video\/\">Making of the Excel Addition Video<\/a>\u00a0to see how we made the video.<\/p>\n<h2>Transcript<\/h2>\n<p>1<br \/>\n00:00:00,0 –> 00:00:02,320<br \/>\n– [Narrator] Would you<br \/>\nbelieve Microsoft Excel<\/p>\n<p>2<br \/>\n00:00:02,320 –> 00:00:05,560<br \/>\ncannot add up these three simple numbers?<\/p>\n<p>3<br \/>\n00:00:05,560 –> 00:00:07,760<br \/>\nTry it in Excel yourself,<\/p>\n<p>4<br \/>\n00:00:07,760 –> 00:00:10,520<br \/>\nbut not until you’ve watched this video.<\/p>\n<p>5<br \/>\n00:00:10,520 –> 00:00:13,280<br \/>\n(relaxing music)<\/p>\n<p>6<br \/>\n00:00:19,600 –> 00:00:21,400<br \/>\nMinus 123.45<\/p>\n<p>7<br \/>\n00:00:22,320 –> 00:00:23,880<br \/>\n123<\/p>\n<p>8<br \/>\n00:00:24,600 –> 00:00:27,360<br \/>\n.45<\/p>\n<p>9<br \/>\n00:00:27,360 –> 00:00:28,200<br \/>\nAutoSum.<\/p>\n<p>10<br \/>\n00:00:31,840 –> 00:00:33,240<br \/>\nThat’s not right.<\/p>\n<p>11<br \/>\n00:00:34,720 –> 00:00:36,440<br \/>\n– Look’s like you’ve got a bug.<\/p>\n<p>12<br \/>\n00:00:36,440 –> 00:00:38,280<br \/>\nLet me get it for you.<\/p>\n<p>13<br \/>\n00:00:39,440 –> 00:00:41,160<br \/>\n– Who are you?<\/p>\n<p>14<br \/>\n00:00:41,160 –> 00:00:44,200<br \/>\nWhat are you doing in my computer?<\/p>\n<p>15<br \/>\n00:00:44,200 –> 00:00:47,160<br \/>\nAh no, I think I’ve got another virus.<\/p>\n<p>16<br \/>\n00:00:47,160 –> 00:00:49,720<br \/>\nHey Marge, those kids<br \/>\nhave been downloading<\/p>\n<p>17<br \/>\n00:00:49,720 –> 00:00:53,360<br \/>\nvirus-infected Minecraft mods again.<\/p>\n<p>18<br \/>\n00:00:53,360 –> 00:00:54,840<br \/>\n– Will you relax?<\/p>\n<p>19<br \/>\n00:00:54,840 –> 00:00:58,40<br \/>\nI’m not a virus, I don’t<br \/>\nwant your credit card,<\/p>\n<p>20<br \/>\n00:00:58,40 –> 00:00:59,800<br \/>\nI don’t want your bank account,<\/p>\n<p>21<br \/>\n00:00:59,800 –> 00:01:01,320<br \/>\nI’m here to help.<\/p>\n<p>22<br \/>\n00:01:01,320 –> 00:01:03,200<br \/>\nLook, people put up for years<\/p>\n<p>23<br \/>\n00:01:03,200 –> 00:01:06,80<br \/>\nwith a bouncing talking<br \/>\npaperclip didn’t they?<\/p>\n<p>24<br \/>\n00:01:06,80 –> 00:01:08,160<br \/>\n– Will you get out of here?<\/p>\n<p>25<br \/>\n00:01:08,160 –> 00:01:10,200<br \/>\nLook, I can fix this myself.<\/p>\n<p>26<br \/>\n00:01:10,200 –> 00:01:13,440<br \/>\nI’ll just add them together<br \/>\nusing lots of plusses.<\/p>\n<p>27<br \/>\n00:01:13,440 –> 00:01:15,520<br \/>\n– It’s not going to work.<\/p>\n<p>28<br \/>\n00:01:19,640 –> 00:01:23,560<br \/>\n– [Narrator] Copy here,<br \/>\nequals this, plus this,<\/p>\n<p>29<br \/>\n00:01:26,560 –> 00:01:27,920<br \/>\nplus this, bang.<\/p>\n<p>30<br \/>\n00:01:30,880 –> 00:01:31,720<br \/>\nWhat?<\/p>\n<p>31<br \/>\n00:01:32,640 –> 00:01:34,80<br \/>\nIt’s still wrong.<\/p>\n<p>32<br \/>\n00:01:36,240 –> 00:01:39,240<br \/>\nSo what is minus 2.83107E-15 anyway?<\/p>\n<p>33<br \/>\n00:01:42,760 –> 00:01:44,440<br \/>\nI mean, is that even a number?<\/p>\n<p>34<br \/>\n00:01:44,440 –> 00:01:47,520<br \/>\nMinus 2.8E-15 is scientific notation.<\/p>\n<p>35<br \/>\n00:01:48,720 –> 00:01:51,560<br \/>\nIt means negative decimal point<\/p>\n<p>36<br \/>\n00:01:51,560 –> 00:01:54,840<br \/>\nfollowed by 14 zeros, two eight.<\/p>\n<p>37<br \/>\n00:01:54,840 –> 00:01:57,840<br \/>\nOkay, but that still doesn’t<br \/>\nexplain why it’s wrong.<\/p>\n<p>38<br \/>\n00:01:57,840 –> 00:02:01,600<br \/>\nNumbers are firstly converted<br \/>\ninto binary representations<\/p>\n<p>39<br \/>\n00:02:01,600 –> 00:02:04,0<br \/>\nmade up of ones and zeroes.<\/p>\n<p>40<br \/>\n00:02:04,0 –> 00:02:06,720<br \/>\nUnfortunately for decimal numbers,<\/p>\n<p>41<br \/>\n00:02:06,720 –> 00:02:10,960<br \/>\nthese binary representations<br \/>\nare not always accurate.<\/p>\n<p>42<br \/>\n00:02:10,960 –> 00:02:13,280<br \/>\nSo when the binary ones and zeroes<\/p>\n<p>43<br \/>\n00:02:13,280 –> 00:02:15,960<br \/>\nare converted back to decimal,<\/p>\n<p>44<br \/>\n00:02:15,960 –> 00:02:17,800<br \/>\nsmall errors creep in.<\/p>\n<p>45<br \/>\n00:02:18,800 –> 00:02:22,680<br \/>\nAdding decimals together<br \/>\ncan make it even worse.<\/p>\n<p>46<br \/>\n00:02:22,680 –> 00:02:24,680<br \/>\nThis is all done according to<\/p>\n<p>47<br \/>\n00:02:24,680 –> 00:02:28,40<br \/>\na rather ancient electrical standard,<\/p>\n<p>48<br \/>\n00:02:28,40 –> 00:02:30,880<br \/>\nNot that old, more like 1975,<\/p>\n<p>49<br \/>\n00:02:30,880 –> 00:02:32,240<br \/>\ncalled IEEE 754.<\/p>\n<p>50<br \/>\n00:02:34,240 –> 00:02:37,0<br \/>\n– Now here is where it<br \/>\ngets really interesting,<\/p>\n<p>51<br \/>\n00:02:37,0 –> 00:02:39,760<br \/>\ntry that calculation again but this time,<\/p>\n<p>52<br \/>\n00:02:39,760 –> 00:02:43,200<br \/>\nput the negative number on the bottom<\/p>\n<p>53<br \/>\n00:02:43,200 –> 00:02:44,880<br \/>\nand see how it goes.<\/p>\n<p>54<br \/>\n00:02:50,440 –> 00:02:53,40<br \/>\nSee, I told you I could help.<\/p>\n<p>55<br \/>\n00:02:53,40 –> 00:02:55,560<br \/>\n– [Narrator] So all I have to<br \/>\ndo is put the negative figures<\/p>\n<p>56<br \/>\n00:02:55,560 –> 00:02:57,160<br \/>\nat the bottom of my list.<\/p>\n<p>57<br \/>\n00:02:57,160 –> 00:02:59,160<br \/>\n– No, we just got lucky.<\/p>\n<p>58<br \/>\n00:03:00,40 –> 00:03:02,320<br \/>\n– So what does Microsoft say?<\/p>\n<p>59<br \/>\n00:03:02,320 –> 00:03:04,360<br \/>\nAre they doing anything about it?<\/p>\n<p>60<br \/>\n00:03:04,360 –> 00:03:08,40<br \/>\n– Keep in mind this error<br \/>\nhas been in Microsoft Excel<\/p>\n<p>61<br \/>\n00:03:08,40 –> 00:03:10,40<br \/>\nsince version 1.0,<\/p>\n<p>62<br \/>\n00:03:10,40 –> 00:03:11,800<br \/>\nthat’s over 30 years.<\/p>\n<p>63<br \/>\n00:03:12,800 –> 00:03:14,920<br \/>\nAccording to Microsoft’s website<\/p>\n<p>64<br \/>\n00:03:14,920 –> 00:03:17,760<br \/>\nthey implement IEEE 754 correctly.<\/p>\n<p>65<br \/>\n00:03:20,560 –> 00:03:22,760<br \/>\nThey note the limitations<\/p>\n<p>66<br \/>\n00:03:22,760 –> 00:03:25,760<br \/>\nbut they recommend going into ‘Options’<\/p>\n<p>67<br \/>\n00:03:25,760 –> 00:03:26,560<br \/>\n‘Advanced’<\/p>\n<p>68<br \/>\n00:03:27,640 –> 00:03:30,200<br \/>\nscroll all the way to the bottom<\/p>\n<p>69<br \/>\n00:03:30,200 –> 00:03:33,600<br \/>\nand click on ‘Set precision as displayed’<\/p>\n<p>70<br \/>\n00:03:34,520 –> 00:03:36,480<br \/>\nbut guess what Microsoft?<\/p>\n<p>71<br \/>\n00:03:36,480 –> 00:03:37,800<br \/>\nIt doesn’t work.<\/p>\n<p>72<br \/>\n00:03:39,80 –> 00:03:41,160<br \/>\n– [Narrator] In primary<br \/>\nschool, children are taught<\/p>\n<p>73<br \/>\n00:03:41,160 –> 00:03:44,440<br \/>\nthat when adding or subtracting<br \/>\nnumbers with decimals,<\/p>\n<p>74<br \/>\n00:03:44,440 –> 00:03:48,0<br \/>\nthe maximum number of<br \/>\ndecimal places in the answer<\/p>\n<p>75<br \/>\n00:03:48,0 –> 00:03:52,160<br \/>\ncan only be the maximum<br \/>\nnumber of decimal places<\/p>\n<p>76<br \/>\n00:03:52,160 –> 00:03:55,80<br \/>\nin any of the numbers in the sum.<\/p>\n<p>77<br \/>\n00:03:55,80 –> 00:03:59,760<br \/>\n– The specification IEEE<br \/>\n754 is seriously lacking<\/p>\n<p>78<br \/>\n00:03:59,760 –> 00:04:01,600<br \/>\nif it does not perform this check<\/p>\n<p>79<br \/>\n00:04:01,600 –> 00:04:03,280<br \/>\nat the end of a calculation.<\/p>\n<p>80<br \/>\n00:04:03,280 –> 00:04:07,160<br \/>\nEspecially if it expects<br \/>\nto have rounding errors.<\/p>\n<p>81<br \/>\n00:04:07,160 –> 00:04:09,600<br \/>\nWhen IEEE 754 was created,<\/p>\n<p>82<br \/>\n00:04:09,600 –> 00:04:12,960<br \/>\ncomputers were a lot<br \/>\nslower than they are today.<\/p>\n<p>83<br \/>\n00:04:12,960 –> 00:04:15,280<br \/>\nThey had a lot fewer cycles.<\/p>\n<p>84<br \/>\n00:04:16,480 –> 00:04:18,880<br \/>\n– [Narrator] Not those kind of cycles.<\/p>\n<p>85<br \/>\n00:04:18,880 –> 00:04:21,40<br \/>\nComputer processor cycles.<\/p>\n<p>86<br \/>\n00:04:22,120 –> 00:04:26,560<br \/>\nNo that’s an analog cycle,<br \/>\nwe want a digital cycle.<\/p>\n<p>87<br \/>\n00:04:26,560 –> 00:04:28,40<br \/>\nThat’s the one.<\/p>\n<p>88<br \/>\n00:04:28,40 –> 00:04:29,800<br \/>\nMuch faster.<\/p>\n<p>89<br \/>\n00:04:29,800 –> 00:04:30,880<br \/>\nFaster still.<\/p>\n<p>90<br \/>\n00:04:33,440 –> 00:04:36,920<br \/>\n– Anyway, there were so<br \/>\nmany spare CPU cycles<\/p>\n<p>91<br \/>\n00:04:36,920 –> 00:04:38,320<br \/>\nthat they could have used them<\/p>\n<p>92<br \/>\n00:04:38,320 –> 00:04:41,160<br \/>\nto calculate the correct<br \/>\nnumber of decimal places,<\/p>\n<p>93<br \/>\n00:04:41,160 –> 00:04:44,760<br \/>\nbut instead of doing that<br \/>\nthey created Mr Clippy,<\/p>\n<p>94<br \/>\n00:04:44,760 –> 00:04:47,240<br \/>\nan idea they later killed off.<\/p>\n<p>95<br \/>\n00:04:48,160 –> 00:04:50,640<br \/>\n– They killed Mr Clippy?<\/p>\n<p>96<br \/>\n00:04:50,640 –> 00:04:54,920<br \/>\n– Ah sweetie, he was very old<br \/>\nand he lived a happy life.<\/p>\n<p>97<br \/>\n00:04:54,920 –> 00:04:57,120<br \/>\nHere’s Mrs Clippy, go play with her.<\/p>\n<p>98<br \/>\n00:04:57,120 –> 00:04:58,0<br \/>\n– Yay!<\/p>\n<p>99<br \/>\n00:04:58,0 –> 00:04:59,360<br \/>\n– And here’s some Clippettes.<\/p>\n<p>100<br \/>\n00:04:59,360 –> 00:05:00,200<br \/>\n– Oh boy!<\/p>\n<p>101<br \/>\n00:05:02,880 –> 00:05:05,0<br \/>\n– Now, where was I?<\/p>\n<p>102<br \/>\n00:05:05,0 –> 00:05:06,400<br \/>\nOh yes.<\/p>\n<p>103<br \/>\n00:05:06,400 –> 00:05:08,600<br \/>\nToday’s computers are so fast<\/p>\n<p>104<br \/>\n00:05:08,600 –> 00:05:11,480<br \/>\nthat Microsoft could<br \/>\nperform the calculation<\/p>\n<p>105<br \/>\n00:05:11,480 –> 00:05:13,40<br \/>\naccording to the standard<\/p>\n<p>106<br \/>\n00:05:13,40 –> 00:05:14,840<br \/>\nbut then check the precision<\/p>\n<p>107<br \/>\n00:05:14,840 –> 00:05:18,160<br \/>\nto the correct number of decimal places<\/p>\n<p>108<br \/>\n00:05:18,160 –> 00:05:21,160<br \/>\nwhich is exactly what Google do.<\/p>\n<p>109<br \/>\n00:05:21,160 –> 00:05:22,560<br \/>\n– [Narrator] That’s right,<\/p>\n<p>110<br \/>\n00:05:22,560 –> 00:05:26,160<br \/>\nthe error doesn’t happen in Google Sheets.<\/p>\n<p>111<br \/>\n00:05:26,160 –> 00:05:29,0<br \/>\nI guess Google don’t let<br \/>\nstandards get in the way<\/p>\n<p>112<br \/>\n00:05:29,0 –> 00:05:30,440<br \/>\nof a correct answer.<\/p>\n<p>113<br \/>\n00:05:30,440 –> 00:05:33,80<br \/>\nYeah, and they also don’t<br \/>\nhave that mongrel ribbon.<\/p>\n<p>114<br \/>\n00:05:33,80 –> 00:05:34,960<br \/>\nSo isn’t there anything I can do?<\/p>\n<p>115<br \/>\n00:05:34,960 –> 00:05:36,240<br \/>\n– Yes there is,<\/p>\n<p>116<br \/>\n00:05:36,240 –> 00:05:40,680<br \/>\nplease share this video with<br \/>\nyour friends and colleagues.<\/p>\n<p>117<br \/>\n00:05:40,680 –> 00:05:42,240<br \/>\nIf we can get enough support,<\/p>\n<p>118<br \/>\n00:05:42,240 –> 00:05:46,40<br \/>\nmaybe Microsoft will<br \/>\nfinally fix this problem.<\/p>\n<p>119<br \/>\n00:05:46,40 –> 00:05:48,480<br \/>\nOh and please like, or subscribe,<\/p>\n<p>120<br \/>\n00:05:48,480 –> 00:05:51,800<br \/>\nso that you can get more<br \/>\ninformative and entertaining videos<\/p>\n<p>121<br \/>\n00:05:51,800 –> 00:05:53,680<br \/>\njust like this one.<\/p>\n<p>122<br \/>\n00:05:53,680 –> 00:05:54,720<br \/>\nThanks for watching.<\/p>\n<p>123<br \/>\n00:05:54,720 –> 00:05:57,480<br \/>\n(relaxing music)<\/p>\n<p>124<br \/>\n00:06:14,840 –> 00:06:15,760<br \/>\nHi sweetie.<\/p>\n<p>125<br \/>\n00:06:17,200 –> 00:06:18,760<br \/>\nWhat are you doing?<\/p>\n<p>126<br \/>\n00:06:20,320 –> 00:06:22,320<br \/>\nDon’t click that!<\/p>\n<p>127<br \/>\n00:06:22,320 –> 00:06:24,880<br \/>\n– [Daughter] You’re bad, Daddy.<\/p>\n<p>128<br \/>\n00:06:29,200 –> 00:06:31,0<br \/>\n– Not Comic Sans!<\/p>\n<p>129<br \/>\n00:06:31,0 –> 00:06:33,800<br \/>\n– [Daughter] You’re funny, Daddy.<\/p>\n<p>130<br \/>\n00:06:33,800 –> 00:06:35,800<br \/>\nNow you’re a good Daddy.<\/p>\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.<\/p>\n","protected":false},"author":1,"featured_media":757,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"inline_featured_image":false,"mc4wp_mailchimp_campaign":[],"footnotes":""},"categories":[20],"tags":[],"class_list":["post-754","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-microsoft-excel","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Microsoft Excel Addition Bug Video - I.T. Guaranteed<\/title>\r\n<meta name=\"description\" content=\"Microsoft Excel Addition Bug Video. Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Microsoft Excel Addition Bug Video - I.T. Guaranteed\" \/>\r\n<meta property=\"og:description\" content=\"Microsoft Excel Addition Bug Video. Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/\" \/>\r\n<meta property=\"og:site_name\" content=\"I.T. Guaranteed\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/I.T.Guaranteed\" \/>\r\n<meta property=\"article:published_time\" content=\"2018-04-12T03:58:06+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2018-12-03T04:49:28+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"500\" \/>\r\n\t<meta property=\"og:image:height\" content=\"280\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\r\n<meta name=\"author\" content=\"Jay Burleigh\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jay Burleigh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/\",\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/\",\"name\":\"Microsoft Excel Addition Bug Video - I.T. Guaranteed\",\"isPartOf\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg\",\"datePublished\":\"2018-04-12T03:58:06+00:00\",\"dateModified\":\"2018-12-03T04:49:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea\"},\"description\":\"Microsoft Excel Addition Bug Video. Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.\",\"inLanguage\":\"en-AU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/#primaryimage\",\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg\",\"contentUrl\":\"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg\",\"width\":500,\"height\":280,\"caption\":\"Microsoft Excel Addition Bug\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#website\",\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/\",\"name\":\"I.T. Guaranteed\",\"description\":\"- Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.itguaranteed.com.au\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-AU\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea\",\"name\":\"Jay Burleigh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-AU\",\"@id\":\"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g\",\"caption\":\"Jay Burleigh\"},\"sameAs\":[\"https:\/\/www.facebook.com\/I.T.Guaranteed\",\"https:\/\/x.com\/ITGuaranteed\"],\"url\":\"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/author\/jay\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel Addition Bug Video - I.T. Guaranteed","description":"Microsoft Excel Addition Bug Video. Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.","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.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel Addition Bug Video - I.T. Guaranteed","og_description":"Microsoft Excel Addition Bug Video. Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.","og_url":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/","og_site_name":"I.T. Guaranteed","article_author":"https:\/\/www.facebook.com\/I.T.Guaranteed","article_published_time":"2018-04-12T03:58:06+00:00","article_modified_time":"2018-12-03T04:49:28+00:00","og_image":[{"width":500,"height":280,"url":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg","type":"image\/jpeg"}],"author":"Jay Burleigh","twitter_misc":{"Written by":"Jay Burleigh","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/","url":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/","name":"Microsoft Excel Addition Bug Video - I.T. Guaranteed","isPartOf":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/#primaryimage"},"image":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/#primaryimage"},"thumbnailUrl":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg","datePublished":"2018-04-12T03:58:06+00:00","dateModified":"2018-12-03T04:49:28+00:00","author":{"@id":"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea"},"description":"Microsoft Excel Addition Bug Video. Would you believe Microsoft Excel cannot add up these 3 simple numbers without getting an error. Try it yourself, but not before you watch this video.","inLanguage":"en-AU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/"]}]},{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/excel-addition-bug-video\/#primaryimage","url":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg","contentUrl":"https:\/\/www.itguaranteed.com.au\/blog\/wp-content\/uploads\/2018\/04\/Microsoft-Excel-Addition-Bug-Video-T.jpg","width":500,"height":280,"caption":"Microsoft Excel Addition Bug"},{"@type":"WebSite","@id":"https:\/\/www.itguaranteed.com.au\/blog\/#website","url":"https:\/\/www.itguaranteed.com.au\/blog\/","name":"I.T. Guaranteed","description":"- Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itguaranteed.com.au\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-AU"},{"@type":"Person","@id":"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/ff702ca7cb4c7573ea3676dee72796ea","name":"Jay Burleigh","image":{"@type":"ImageObject","inLanguage":"en-AU","@id":"https:\/\/www.itguaranteed.com.au\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82a28fb608f00f74a687d37d3a6c98d7?s=96&d=mm&r=g","caption":"Jay Burleigh"},"sameAs":["https:\/\/www.facebook.com\/I.T.Guaranteed","https:\/\/x.com\/ITGuaranteed"],"url":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/author\/jay\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts\/754"}],"collection":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=754"}],"version-history":[{"count":7,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts\/754\/revisions"}],"predecessor-version":[{"id":782,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/posts\/754\/revisions\/782"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/media\/757"}],"wp:attachment":[{"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itguaranteed.com.au\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}