{"id":1708,"date":"2016-11-21T08:00:45","date_gmt":"2016-11-20T23:00:45","guid":{"rendered":"https:\/\/norimen.net\/wordpress\/?p=1708"},"modified":"2026-05-15T19:38:29","modified_gmt":"2026-05-15T10:38:29","slug":"excel-rounding-error-calculation","status":"publish","type":"post","link":"https:\/\/norimen.net\/en\/excel-rounding-error-calculation\/","title":{"rendered":"Excel Quirks | Why Calculation Results Can Be Off Due to the Accumulation of Fractional Values"},"content":{"rendered":"<p>Hello, everyone.<\/p>\n<p>This is Enta.<\/p>\n<p>The other night, my seniors invited me out for drinks.<\/p>\n<p>At that time, I ordered tomato pasta for delivery lol<\/p>\n<p>The party was over, so I went home and went to bed, but I had a stomachache...<\/p>\n<p>My stomach really has gotten weaker, hasn't it?<\/p>\n<p>On top of that, the year-end party season is just around the corner.<\/p>\n<p>I can't live without Ota-I-San, lol.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1720\" src=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/00000001983629_A03.jpg\" alt=\"Ota-I-San\" width=\"600\" height=\"600\" srcset=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/00000001983629_A03.jpg 600w, https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/00000001983629_A03-150x150.jpg 150w, https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/00000001983629_A03-300x300.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<hr \/>\n<p>But that's beside the point.<\/p>\n<p>Do you know about Excel's quirks?<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1721\" src=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/53dba75c166e3d119560fd11c0a3756b.jpg\" alt=\"Excel\" width=\"443\" height=\"460\" srcset=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/53dba75c166e3d119560fd11c0a3756b.jpg 443w, https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/53dba75c166e3d119560fd11c0a3756b-289x300.jpg 289w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/p>\n<p>It's just that I have a habit of doing the math, lol.<\/p>\n<p>It goes without saying, lol<\/p>\n<p>&nbsp;<\/p>\n<p>If you let Excel do the calculations, you'll get the answer.<\/p>\n<p>&nbsp;<\/p>\n<p>It's actually pretty hard to come up with an example, but,<\/p>\n<p>When you use a calculated answer to find another answer,<\/p>\n<p>If possible, it's important to convert it back to an integer.<\/p>\n<p>Truncating the decimal places, rounding to the second decimal place, and so on<\/p>\n<p>If you don't round off the fractions, they'll just keep adding up.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff; font-size: 18px;\"><strong>The accumulated fractions result in an answer different from that obtained by hand.<\/strong><\/span><\/p>\n<p>Let's be careful.<\/p>\n<p>&nbsp;<\/p>\n<p>Well, that's it for now.<\/p>","protected":false},"excerpt":{"rendered":"<p>Hello, everyone. It\u2019s Enta here. The other night, some of my seniors invited me out for drinks. We ordered tomato pasta for delivery while we were there, lol. After the gathering ended, I went home and went to bed, but I ended up with a stomachache\u2026 Seriously, my stomach has really gotten weaker. And on top of that, from now on\u2026<\/p>","protected":false},"author":2,"featured_media":1722,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[32],"tags":[58,79,80,81],"class_list":["post-1708","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-documentation","tag-58","tag-excel","tag-80","tag-81"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.2 (Yoast SEO v28.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531 - \u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e<\/title>\n<meta name=\"description\" content=\"\u30a8\u30af\u30bb\u30eb\u3067\u8a08\u7b97\u7d50\u679c\u3092\u518d\u5229\u7528\u3059\u308b\u3068\u7aef\u6570\u304c\u84c4\u7a4d\u3057\u624b\u8a08\u7b97\u3068\u7570\u306a\u308b\u7b54\u3048\u306b\u306a\u308b\u3002\u6574\u6570\u5316\u3084\u56db\u6368\u4e94\u5165\u3067\u7aef\u6570\u7ba1\u7406\u3059\u308b\u91cd\u8981\u6027\u3092\u5efa\u8a2d\u696d\u5b9f\u52d9\u76ee\u7dda\u3067\u89e3\u8aac\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/norimen.net\/en\/excel-rounding-error-calculation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\" \/>\n<meta property=\"og:description\" content=\"\u30a8\u30af\u30bb\u30eb\u3067\u8a08\u7b97\u7d50\u679c\u3092\u518d\u5229\u7528\u3059\u308b\u3068\u7aef\u6570\u304c\u84c4\u7a4d\u3057\u624b\u8a08\u7b97\u3068\u7570\u306a\u308b\u7b54\u3048\u306b\u306a\u308b\u3002\u6574\u6570\u5316\u3084\u56db\u6368\u4e94\u5165\u3067\u7aef\u6570\u7ba1\u7406\u3059\u308b\u91cd\u8981\u6027\u3092\u5efa\u8a2d\u696d\u5b9f\u52d9\u76ee\u7dda\u3067\u89e3\u8aac\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/norimen.net\/en\/excel-rounding-error-calculation\/\" \/>\n<meta property=\"og:site_name\" content=\"\u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/norimenman\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/norimenman\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-20T23:00:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-15T10:38:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/Excel2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"460\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u30a8\u30f3\u30bf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@norimenman\" \/>\n<meta name=\"twitter:site\" content=\"@norimenman\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u30a8\u30f3\u30bf\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/\"},\"author\":{\"name\":\"\u30a8\u30f3\u30bf\",\"@id\":\"https:\\\/\\\/norimen.net\\\/#\\\/schema\\\/person\\\/7e507d48b040ed0f7a88ef4625070b95\"},\"headline\":\"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\",\"datePublished\":\"2016-11-20T23:00:45+00:00\",\"dateModified\":\"2026-05-15T10:38:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/\"},\"wordCount\":6,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/Excel2.jpg\",\"keywords\":[\"\u65bd\u5de5\u7ba1\u7406\",\"Excel\",\"\u30a8\u30af\u30bb\u30eb\",\"\u66f8\u985e\u6574\u7406\"],\"articleSection\":[\"\u66f8\u985e\u6574\u7406\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/\",\"url\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/\",\"name\":\"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531 - \u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/Excel2.jpg\",\"datePublished\":\"2016-11-20T23:00:45+00:00\",\"dateModified\":\"2026-05-15T10:38:29+00:00\",\"description\":\"\u30a8\u30af\u30bb\u30eb\u3067\u8a08\u7b97\u7d50\u679c\u3092\u518d\u5229\u7528\u3059\u308b\u3068\u7aef\u6570\u304c\u84c4\u7a4d\u3057\u624b\u8a08\u7b97\u3068\u7570\u306a\u308b\u7b54\u3048\u306b\u306a\u308b\u3002\u6574\u6570\u5316\u3084\u56db\u6368\u4e94\u5165\u3067\u7aef\u6570\u7ba1\u7406\u3059\u308b\u91cd\u8981\u6027\u3092\u5efa\u8a2d\u696d\u5b9f\u52d9\u76ee\u7dda\u3067\u89e3\u8aac\u3002\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#primaryimage\",\"url\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/Excel2.jpg\",\"contentUrl\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/11\\\/Excel2.jpg\",\"width\":600,\"height\":460},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/norimen.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/norimen.net\\\/#website\",\"url\":\"https:\\\/\\\/norimen.net\\\/\",\"name\":\"\u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e\",\"description\":\"\u6cd5\u9762\u306e\u4e8b\u3092\u672c\u6c17\u3067\u77e5\u308a\u305f\u3044\u3042\u306a\u305f\u3078\uff01\",\"publisher\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/#organization\"},\"alternateName\":\"\u30a8\u30f3\u30bf\u306e\u30ce\u30ea\u30e1\u30f3\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/norimen.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Organization\",\"Place\"],\"@id\":\"https:\\\/\\\/norimen.net\\\/#organization\",\"name\":\"\u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e\",\"alternateName\":\"\u5869\u7530\u958b\u767a\u682a\u5f0f\u4f1a\u793e\",\"url\":\"https:\\\/\\\/norimen.net\\\/\",\"logo\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#local-main-organization-logo\"},\"image\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#local-main-organization-logo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/norimenman\",\"https:\\\/\\\/x.com\\\/norimenman\",\"https:\\\/\\\/www.instagram.com\\\/enta.d\"],\"telephone\":[],\"openingHoursSpecification\":[{\"@type\":\"OpeningHoursSpecification\",\"dayOfWeek\":[\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\",\"Sunday\"],\"opens\":\"09:00\",\"closes\":\"17:00\"}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/norimen.net\\\/#\\\/schema\\\/person\\\/7e507d48b040ed0f7a88ef4625070b95\",\"name\":\"\u30a8\u30f3\u30bf\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7b9657262458e754e6e51a10396868dafe6afa60d649dffcd4d52a5fc01aaa7d?s=96&d=monsterid&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7b9657262458e754e6e51a10396868dafe6afa60d649dffcd4d52a5fc01aaa7d?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7b9657262458e754e6e51a10396868dafe6afa60d649dffcd4d52a5fc01aaa7d?s=96&d=monsterid&r=g\",\"caption\":\"\u30a8\u30f3\u30bf\"},\"description\":\"\u5927\u624b\u6cd5\u9762\u5c02\u9580\u5efa\u8a2d\u4f1a\u793e\u306b\u5c31\u8077\u5f8c\u300132\u6b73\u3067\u72ec\u7acb\u3002 \u3042\u307e\u308a\u306e\u6687\u3055\u306b\u30d6\u30ed\u30b0\u3092\u958b\u8a2d\u3002\u6cd5\u9762\u306e\u30ce\u30a6\u30cf\u30a6\u3092\u516c\u958b\u3057\u3001\u3042\u308a\u3068\u3042\u3089\u3086\u308b\u8cea\u554f\u306b\u7b54\u3048\u3066\u304d\u307e\u3057\u305f\u3002 \u305d\u306e\u7d50\u679c\u3001\u6cd5\u9762\u696d\u8005\u3001\u5143\u8acb\u696d\u8005\u3001\u305d\u306e\u4ed6\u30bc\u30cd\u30b3\u30f3\u304b\u3089\u306e\u554f\u3044\u5408\u308f\u305b\u3001\u8cea\u554f\u3001\u53d7\u6ce8\u304c\u5897\u3048\u3066\u304d\u307e\u3057\u305f\u3002 \u30a2\u30e1\u30d6\u30ed\u3067\u306f\u30bd\u30b3\u30bd\u30b3\u95b2\u89a7\u304c\u5897\u3048\u3001 \u305d\u3053\u3067\u72ec\u81ea\u30c9\u30e1\u30a4\u30f3\u3092\u53d6\u5f97\u3057\u5c11\u3057\u3067\u3082\u5feb\u9069\u306a\u30d6\u30ed\u30b0\u3092\u76ee\u5dee\u3059\u3079\u304f\u3001\u30a2\u30e1\u30d6\u30ed\u304b\u3089\u306e\u5352\u696d\u3092\u6c7a\u3081\u307e\u3057\u305f\u3002 \u4eca\u5f8c\u3082\u3053\u3061\u3089\u3067\u5305\u307f\u96a0\u3055\u305a\u5168\u3066\u306e\u30ce\u30a6\u30cf\u30a6\u3092\u516c\u958b\u3057\u3066\u3044\u3053\u3046\u3068\u601d\u3063\u3066\u3044\u307e\u3059\u3002 \u4eca\u5f8c\u3068\u3082\u3088\u308d\u3057\u304f\u304a\u9858\u3044\u7533\u3057\u4e0a\u3052\u307e\u3059\u3002\",\"sameAs\":[\"http:\\\/\\\/enta-d.co.jp\\\/\",\"https:\\\/\\\/www.facebook.com\\\/norimenman\\\/\",\"https:\\\/\\\/www.instagram.com\\\/enta.d\\\/\",\"https:\\\/\\\/x.com\\\/norimenman\",\"https:\\\/\\\/www.youtube.com\\\/c\\\/entadnorimenman\"]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-calculation\\\/#local-main-organization-logo\",\"url\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/site_title_logo.png\",\"contentUrl\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2016\\\/10\\\/site_title_logo.png\",\"width\":220,\"height\":50,\"caption\":\"\u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Quirks | Why Calculation Results Can Be Off Due to the Accumulation of Fractional Values - Shin-Ent's Slope Management School","description":"When calculation results are reused in Excel, fractional values accumulate, leading to answers that differ from those obtained by hand. This article explains the importance of managing fractional values through rounding and converting to integers from the perspective of construction industry practices.","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:\/\/norimen.net\/en\/excel-rounding-error-calculation\/","og_locale":"en_US","og_type":"article","og_title":"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531","og_description":"\u30a8\u30af\u30bb\u30eb\u3067\u8a08\u7b97\u7d50\u679c\u3092\u518d\u5229\u7528\u3059\u308b\u3068\u7aef\u6570\u304c\u84c4\u7a4d\u3057\u624b\u8a08\u7b97\u3068\u7570\u306a\u308b\u7b54\u3048\u306b\u306a\u308b\u3002\u6574\u6570\u5316\u3084\u56db\u6368\u4e94\u5165\u3067\u7aef\u6570\u7ba1\u7406\u3059\u308b\u91cd\u8981\u6027\u3092\u5efa\u8a2d\u696d\u5b9f\u52d9\u76ee\u7dda\u3067\u89e3\u8aac\u3002","og_url":"https:\/\/norimen.net\/en\/excel-rounding-error-calculation\/","og_site_name":"\u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e","article_publisher":"https:\/\/www.facebook.com\/norimenman","article_author":"https:\/\/www.facebook.com\/norimenman\/","article_published_time":"2016-11-20T23:00:45+00:00","article_modified_time":"2026-05-15T10:38:29+00:00","og_image":[{"width":600,"height":460,"url":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/Excel2.jpg","type":"image\/jpeg"}],"author":"\u30a8\u30f3\u30bf","twitter_card":"summary_large_image","twitter_creator":"@norimenman","twitter_site":"@norimenman","twitter_misc":{"Written by":"\u30a8\u30f3\u30bf"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#article","isPartOf":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/"},"author":{"name":"\u30a8\u30f3\u30bf","@id":"https:\/\/norimen.net\/#\/schema\/person\/7e507d48b040ed0f7a88ef4625070b95"},"headline":"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531","datePublished":"2016-11-20T23:00:45+00:00","dateModified":"2026-05-15T10:38:29+00:00","mainEntityOfPage":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/"},"wordCount":6,"commentCount":0,"publisher":{"@id":"https:\/\/norimen.net\/#organization"},"image":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#primaryimage"},"thumbnailUrl":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/Excel2.jpg","keywords":["\u65bd\u5de5\u7ba1\u7406","Excel","\u30a8\u30af\u30bb\u30eb","\u66f8\u985e\u6574\u7406"],"articleSection":["\u66f8\u985e\u6574\u7406"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/norimen.net\/excel-rounding-error-calculation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/","url":"https:\/\/norimen.net\/excel-rounding-error-calculation\/","name":"Excel Quirks | Why Calculation Results Can Be Off Due to the Accumulation of Fractional Values - Shin-Ent's Slope Management School","isPartOf":{"@id":"https:\/\/norimen.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#primaryimage"},"image":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#primaryimage"},"thumbnailUrl":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/Excel2.jpg","datePublished":"2016-11-20T23:00:45+00:00","dateModified":"2026-05-15T10:38:29+00:00","description":"When calculation results are reused in Excel, fractional values accumulate, leading to answers that differ from those obtained by hand. This article explains the importance of managing fractional values through rounding and converting to integers from the perspective of construction industry practices.","breadcrumb":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/norimen.net\/excel-rounding-error-calculation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#primaryimage","url":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/Excel2.jpg","contentUrl":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/Excel2.jpg","width":600,"height":460},{"@type":"BreadcrumbList","@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/norimen.net\/"},{"@type":"ListItem","position":2,"name":"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u306e\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531"}]},{"@type":"WebSite","@id":"https:\/\/norimen.net\/#website","url":"https:\/\/norimen.net\/","name":"Shin-Ent's Slope Management Seminar","description":"For those of you who are serious about learning about slopes!","publisher":{"@id":"https:\/\/norimen.net\/#organization"},"alternateName":"\u30a8\u30f3\u30bf\u306e\u30ce\u30ea\u30e1\u30f3","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/norimen.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Organization","Place"],"@id":"https:\/\/norimen.net\/#organization","name":"Shin-Ent's Slope Management Seminar","alternateName":"\u5869\u7530\u958b\u767a\u682a\u5f0f\u4f1a\u793e","url":"https:\/\/norimen.net\/","logo":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#local-main-organization-logo"},"image":{"@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#local-main-organization-logo"},"sameAs":["https:\/\/www.facebook.com\/norimenman","https:\/\/x.com\/norimenman","https:\/\/www.instagram.com\/enta.d"],"telephone":[],"openingHoursSpecification":[{"@type":"OpeningHoursSpecification","dayOfWeek":["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"],"opens":"09:00","closes":"17:00"}]},{"@type":"Person","@id":"https:\/\/norimen.net\/#\/schema\/person\/7e507d48b040ed0f7a88ef4625070b95","name":"Entertainment","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/7b9657262458e754e6e51a10396868dafe6afa60d649dffcd4d52a5fc01aaa7d?s=96&d=monsterid&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7b9657262458e754e6e51a10396868dafe6afa60d649dffcd4d52a5fc01aaa7d?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7b9657262458e754e6e51a10396868dafe6afa60d649dffcd4d52a5fc01aaa7d?s=96&d=monsterid&r=g","caption":"\u30a8\u30f3\u30bf"},"description":"After joining a major construction company specializing in slope stabilization, I went independent at the age of 32. With so much free time on my hands, I started a blog. I\u2019ve been sharing my expertise on slope stabilization and answering all kinds of questions. As a result, I\u2019ve seen an increase in inquiries, questions, and orders from slope stabilization contractors, general contractors, and other major construction firms. My traffic on Ameblo grew to a reasonable level, so I decided to move on from Ameblo by acquiring my own domain in order to create a more user-friendly blog. I plan to continue sharing all my expertise openly and honestly here. I look forward to your continued support.","sameAs":["http:\/\/enta-d.co.jp\/","https:\/\/www.facebook.com\/norimenman\/","https:\/\/www.instagram.com\/enta.d\/","https:\/\/x.com\/norimenman","https:\/\/www.youtube.com\/c\/entadnorimenman"]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/norimen.net\/excel-rounding-error-calculation\/#local-main-organization-logo","url":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/10\/site_title_logo.png","contentUrl":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/10\/site_title_logo.png","width":220,"height":50,"caption":"\u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e"}]}},"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"publishpress_future_action":{"enabled":false,"date":"2026-08-20 03:56:55","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"jetpack_featured_media_url":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2016\/11\/Excel2.jpg","_links":{"self":[{"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/posts\/1708","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/comments?post=1708"}],"version-history":[{"count":1,"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/posts\/1708\/revisions"}],"predecessor-version":[{"id":60476,"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/posts\/1708\/revisions\/60476"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/media\/1722"}],"wp:attachment":[{"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/media?parent=1708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/categories?post=1708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/norimen.net\/en\/wp-json\/wp\/v2\/tags?post=1708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}