{"id":65969,"date":"2026-07-05T08:00:39","date_gmt":"2026-07-04T23:00:39","guid":{"rendered":"https:\/\/norimen.net\/?p=65969"},"modified":"2026-07-03T00:21:07","modified_gmt":"2026-07-02T15:21:07","slug":"loi-lam-tron-trong-excel-so-thap-phan-noi-ieee-754","status":"publish","type":"post","link":"https:\/\/norimen.net\/vi\/excel-rounding-error-ieee754-floating-point\/","title":{"rendered":"Nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m ri\u00eang c\u1ee7a Excel | L\u00fd do k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n b\u1ecb sai l\u1ec7ch do t\u00edch l\u0169y s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 ti\u00eau chu\u1ea9n IEEE 754"},"content":{"rendered":"<p>Xin ch\u00e0o m\u1ecdi ng\u01b0\u1eddi.<\/p>\n<p>\u0110\u00e2y l\u00e0 Enta.<\/p>\n<p>B\u1ea1n \u0111\u00e3 bao gi\u1edd g\u1eb7p tr\u01b0\u1eddng h\u1ee3p \u0111ang t\u1ed5ng h\u1ee3p s\u1ed1 l\u01b0\u1ee3ng tr\u00ean Excel m\u00e0 ph\u00e1t hi\u1ec7n ra r\u1eb1ng \u201ckhi c\u1ed9ng t\u1ea5t c\u1ea3 l\u1ea1i, k\u1ebft qu\u1ea3 ch\u00eanh l\u1ec7ch 1 y\u00ean so v\u1edbi k\u1ebft qu\u1ea3 t\u00ednh b\u1eb1ng tay\u201d ch\u01b0a?<\/p>\n<p>Ngay c\u1ea3 trong vi\u1ec7c t\u00ednh to\u00e1n chi ph\u00ed thi c\u00f4ng m\u00e1i d\u1ed1c, n\u1ebfu c\u1ee9 l\u1eb7p \u0111i l\u1eb7p l\u1ea1i c\u00e1c c\u00f4ng th\u1ee9c nh\u01b0 di\u1ec7n t\u00edch \u00d7 \u0111\u01a1n gi\u00e1 \u00d7 thu\u1ebf ti\u00eau d\u00f9ng, th\u00ec,<strong>\u1ede d\u00f2ng cu\u1ed1i c\u00f9ng, ch\u1eafc ch\u1eafn s\u1ebd c\u00f3 s\u1ef1 ch\u00eanh l\u1ec7ch 1 y\u00ean ho\u1eb7c 1 m\u00b2<\/strong>\u0110\u00f3 l\u00e0 m\u1ed9t hi\u1ec7n t\u01b0\u1ee3ng.<\/p>\n<p>\u0110i\u1ec1u n\u00e0y kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ed7i c\u1ee7a Excel m\u00e0 l\u00e0...<strong>IEEE 754 \u2013 Ti\u00eau chu\u1ea9n to\u00e0n c\u1ea7u v\u1ec1 s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng<\/strong>\u0110\u00f3 l\u00e0 l\u00fd do \u0111\u1ea5y w<\/p>\n<p>H\u1ed3i x\u01b0a t\u1edb t\u1eebng r\u1ea5t b\u1ef1c m\u00ecnh n\u00ean \u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 chuy\u1ec7n n\u00e0y, n\u00ean c\u0169ng chia s\u1ebb v\u1edbi m\u1ecdi ng\u01b0\u1eddi lu\u00f4n w<\/p>\n<p>D\u00f9 n\u00f3i v\u1eady, nh\u01b0ng ng\u00e0y nay ng\u01b0\u1eddi ta c\u00f3 c\u00f2n d\u00f9ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n nhi\u1ec1u kh\u00f4ng nh\u1ec9?<\/p>\n<p>T\u00f4i v\u1eabn l\u00e0 ng\u01b0\u1eddi th\u00edch d\u00f9ng Excel!<\/p>\n<p>C\u00e1i n\u00e0y l\u00e0 th\u1ee9 c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c m\u1ecdi th\u1ee9 nh\u1ea5t n\u00ean... w<\/p>\n<hr \/>\n<p>Th\u00f4i, quay l\u1ea1i ch\u1ee7 \u0111\u1ec1 ch\u00ednh<\/p>\n<p>L\u1ea7n n\u00e0y,<strong>B\u1ea3n ch\u1ea5t c\u1ee7a sai s\u1ed1 t\u00edch l\u0169y do s\u1ed1 th\u1eadp ph\u00e2n g\u00e2y ra trong Excel (v\u00e0 nhi\u1ec1u ph\u1ea7n m\u1ec1m kh\u00e1c)<\/strong>,<strong>Th\u00f4ng s\u1ed1 k\u1ef9 thu\u1eadt c\u1ee7a s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng \u0111\u1ed9 ch\u00ednh x\u00e1c g\u1ea5p 754 l\u1ea7n theo ti\u00eau chu\u1ea9n IEEE<\/strong>T\u1eeb \u0111\u00f3,<\/p>\n<p><strong>C\u00e1ch kh\u1eafc ph\u1ee5c \u0111\u00fang b\u1eb1ng h\u00e0m ROUND<\/strong>T\u00f4i s\u1ebd chia s\u1ebb kinh nghi\u1ec7m c\u1ee7a m\u00ecnh khi ph\u1ea3i th\u1ef1c hi\u1ec7n vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 l\u01b0\u1ee3ng m\u1ed9t c\u00e1ch b\u1ef1c b\u1ed9i cho \u0111\u1ebfn l\u00fac \u0111\u00f3.<\/p>\n<p>\u0110\u00e2y l\u00e0 th\u00f4ng tin \u0111\u01b0\u1ee3c n\u00eau r\u00f5 trong t\u00e0i li\u1ec7u ch\u00ednh th\u1ee9c c\u1ee7a Microsoft, n\u00ean c\u01a1 s\u1edf n\u00e0y ch\u1eafc ch\u1eafn l\u00e0 100%.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-65952\" src=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/33c4f23011217a40e453d534eae43a8f.jpg\" alt=\"M\u1ed9t v\u00ed d\u1ee5 \u0111i\u1ec3n h\u00ecnh v\u1ec1 s\u1ef1 ch\u00eanh l\u1ec7ch 1 y\u00ean do t\u00edch l\u0169y s\u1ed1 l\u1ebb\" width=\"600\" height=\"338\" \/><\/p>\n<h2>B\u00ed m\u1eadt \u0111\u1eb1ng sau nh\u1eefng \u201cth\u00f3i quen\u201d c\u1ee7a Excel | Ti\u00eau chu\u1ea9n IEEE 754<\/h2>\n<p>N\u00f3i ng\u1eafn g\u1ecdn th\u00ec,<strong>Sai s\u1ed1 t\u00ednh to\u00e1n trong Excel kh\u00f4ng ph\u1ea3i l\u00e0 l\u1ed7i ph\u1ea7n m\u1ec1m, m\u00e0 l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a vi\u1ec7c tu\u00e2n th\u1ee7 nghi\u00eam ng\u1eb7t ti\u00eau chu\u1ea9n t\u00ednh to\u00e1n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng IEEE 754<\/strong>\u0110\u00f3 l\u00e0.<\/p>\n<p>Ch\u1eafc b\u1ea1n \u0111ang ngh\u0129: \u201cH\u1ea3?\u201d ph\u1ea3i kh\u00f4ng?<\/p>\n<p>&nbsp;<\/p>\n<p>Microsoft \u0111\u00e3 n\u00eau r\u00f5 v\u1ec1 \u0111\u1ed9 ch\u00ednh x\u00e1c t\u00ednh to\u00e1n c\u1ee7a Excel nh\u01b0 sau: Microsoft Excel \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf d\u1ef1a tr\u00ean ti\u00eau chu\u1ea9n IEEE 754, quy \u0111\u1ecbnh c\u00e1ch l\u01b0u tr\u1eef v\u00e0 ph\u01b0\u01a1ng ph\u00e1p t\u00ednh to\u00e1n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng. Excel c\u00f3 th\u1ec3 l\u01b0u tr\u1eef c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb 1,79769313486232E308 \u0111\u1ebfn 2,2250738585072E-308, nh\u01b0ng,<strong>S\u1ed1 ch\u1eef s\u1ed1 c\u00f3 \u00fd ngh\u0129a kh\u00f4ng qu\u00e1 15 ch\u1eef s\u1ed1<\/strong>ch\u1ec9 gi\u1edbi h\u1ea1n \u1edf \u0111\u00f3.<\/p>\n<p><a href=\"https:\/\/learn.microsoft.com\/ja-jp\/office\/troubleshoot\/excel\/floating-point-arithmetic-inaccurate-result\" target=\"_blank\" rel=\"noopener\">T\u00e0i li\u1ec7u ch\u00ednh th\u1ee9c c\u1ee7a Microsoft Learn: \u201cVi\u1ec7c s\u1eed d\u1ee5ng ph\u00e9p t\u00ednh s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng c\u00f3 th\u1ec3 d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 kh\u00f4ng ch\u00ednh x\u00e1c trong Excel\u201d<\/a><\/p>\n<p>N\u00f3i c\u00e1ch kh\u00e1c, Excel th\u1ef1c hi\u1ec7n b\u00ean trong<strong>T\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ec1u \u0111\u01b0\u1ee3c x\u1eed l\u00fd d\u01b0\u1edbi d\u1ea1ng nh\u1ecb ph\u00e2n<\/strong>Do \u0111\u00f3, khi chuy\u1ec3n \u0111\u1ed5i s\u1ed1 \u0111\u01b0\u1ee3c vi\u1ebft d\u01b0\u1edbi d\u1ea1ng th\u1eadp ph\u00e2n sang h\u1ec7 nh\u1ecb ph\u00e2n th\u00ec<strong>Sai s\u1ed1 l\u00e0m tr\u00f2n<\/strong>s\u1ebd ra \u0111\u1eddi.<\/p>\n<p>B\u1ea3n ch\u1ea5t c\u1ee7a hi\u1ec7n t\u01b0\u1ee3ng n\u00e0y ch\u00ednh l\u00e0 vi\u1ec7c c\u00e1c ph\u00e9p t\u00ednh n\u00e0y s\u1ebd t\u00edch l\u0169y d\u1ea7n theo th\u1eddi gian.<\/p>\n<h3>T\u1ea1i sao l\u1ea1i x\u1ea3y ra sai s\u1ed1 khi chuy\u1ec3n \u0111\u1ed5i t\u1eeb h\u1ec7 th\u1eadp ph\u00e2n sang h\u1ec7 nh\u1ecb ph\u00e2n?<\/h3>\n<p>M\u1ed9t s\u1ed1 h\u1eefu h\u1ea1n d\u01b0\u1edbi d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n nh\u01b0 \u201c0,1\u201d,<strong>Trong h\u1ec7 nh\u1ecb ph\u00e2n, s\u1ed1 n\u00e0y s\u1ebd tr\u1edf th\u00e0nh m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n l\u1eb7p l\u1ea1i v\u00f4 h\u1ea1n<\/strong>l\u00e0 nguy\u00ean nh\u00e2n.<\/p>\n<table>\n<thead>\n<tr>\n<th>S\u1ed1 th\u1eadp ph\u00e2n<\/th>\n<th>Bi\u1ec3u di\u1ec5n s\u1ed1 nh\u1ecb ph\u00e2n<\/th>\n<th>Ghi ch\u00fa<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>0.5<\/td>\n<td>0.1<\/td>\n<td>C\u00f3 th\u1ec3 di\u1ec5n \u0111\u1ea1t m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c<\/td>\n<\/tr>\n<tr>\n<td>0.25<\/td>\n<td>0.01<\/td>\n<td>C\u00f3 th\u1ec3 di\u1ec5n \u0111\u1ea1t m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c<\/td>\n<\/tr>\n<tr>\n<td><strong>0.1<\/strong><\/td>\n<td><strong>0,0001100110011\u2026 (l\u1eb7p l\u1ea1i)<\/strong><\/td>\n<td><strong>V\u00f2ng l\u1eb7p v\u00f4 h\u1ea1n, ph\u00e1t sinh sai s\u1ed1 l\u00e0m tr\u00f2n<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>0.2<\/strong><\/td>\n<td><strong>0,0011001100110\u2026 (l\u1eb7p l\u1ea1i)<\/strong><\/td>\n<td><strong>Nh\u01b0 tr\u00ean<\/strong><\/td>\n<\/tr>\n<tr>\n<td>0.3<\/td>\n<td>0,0100110011001\u2026 (l\u1eb7p l\u1ea1i)<\/td>\n<td>Nh\u01b0 tr\u00ean<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong ti\u00eau chu\u1ea9n IEEE 754 \u0111\u1ed9 ch\u00ednh x\u00e1c k\u00e9p (64 bit), v\u00f2ng l\u1eb7p v\u00f4 h\u1ea1n n\u00e0y<strong>C\u1eaft ng\u1eafn \u1edf m\u1ed9t ch\u1eef s\u1ed1 nh\u1ea5t \u0111\u1ecbnh r\u1ed3i l\u01b0u tr\u1eef<\/strong>Do \u0111\u00f3, s\u1ebd ph\u00e1t sinh m\u1ed9t sai s\u1ed1 r\u1ea5t nh\u1ecf (kho\u1ea3ng \u00b12,8 \u00d7 10\u207b\u00b9\u2077) (Microsoft Learn).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-65951\" src=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/40ccd61d4c6ad09e9572b5397d3133e4.jpg\" alt=\"C\u01a1 ch\u1ebf khi\u1ebfn s\u1ed1 th\u1eadp ph\u00e2n 0,1 khi chuy\u1ec3n sang h\u1ec7 nh\u1ecb ph\u00e2n s\u1ebd t\u1ea1o ra m\u1ed9t v\u00f2ng l\u1eb7p v\u00f4 t\u1eadn\" width=\"600\" height=\"338\" \/><\/p>\n<h2>V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 | Nh\u1eefng sai l\u1ec7ch \u0111i\u1ec3n h\u00ecnh th\u01b0\u1eddng x\u1ea3y ra trong Excel<\/h2>\n<h3>Ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n | \u00dd ngh\u0129a c\u1ee7a TRUE v\u00e0 FALSE<\/h3>\n<p>Tr\u01b0\u1edbc khi \u0111i v\u00e0o c\u00e1c v\u00ed d\u1ee5 c\u1ee5 th\u1ec3, trong Excel, <strong>\u0110\u00daNG \/ SAI<\/strong> Ch\u00fang ta s\u1ebd \u00f4n l\u1ea1i n\u1ed9i dung n\u00e0y.<\/p>\n<p>D\u00f9 \u0111\u00e3 mu\u1ed9n, nh\u01b0ng \u0111\u00e2y l\u00e0 ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n nh\u1ea5t trong s\u1ed1 c\u00e1c ki\u1ebfn th\u1ee9c c\u01a1 b\u1ea3n, n\u00ean c\u00e1c b\u1ea1n nh\u1ea5t \u0111\u1ecbnh ph\u1ea3i ghi nh\u1edb nh\u00e9!<\/p>\n<p>Trong Excel <strong>\u201c=\u201d hay \u201c&gt;\u201d hay \u201c&lt;\u201d<\/strong> Khi s\u1eed d\u1ee5ng, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 <strong>TRUE (\u0110\u00fang \u00b7 B\u1eb1ng nhau \/ \u0110\u00fang)<\/strong> \u304b <strong>FALSE (Sai, kh\u00f4ng b\u1eb1ng nhau\/kh\u00f4ng \u0111\u00fang)<\/strong> v\u00e0 s\u1ebd tr\u1ea3 l\u1eddi l\u1ea1i.<\/p>\n<table>\n<thead>\n<tr>\n<th>C\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc<\/th>\n<th>\u00dd ngh\u0129a<\/th>\n<th>K\u1ebft qu\u1ea3<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>=1=1<\/code><\/td>\n<td>1 v\u00e0 1 c\u00f3 b\u1eb1ng nhau kh\u00f4ng?<\/td>\n<td><strong>TRUE<\/strong><\/td>\n<\/tr>\n<tr>\n<td><code>=1=2<\/code><\/td>\n<td>1 v\u00e0 2 c\u00f3 b\u1eb1ng nhau kh\u00f4ng?<\/td>\n<td><strong>FALSE<\/strong><\/td>\n<\/tr>\n<tr>\n<td><code>=5 &gt; 3<\/code><\/td>\n<td>5 l\u1edbn h\u01a1n 3?<\/td>\n<td><strong>TRUE<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>N\u00f3i c\u00e1ch kh\u00e1c <strong>\u300c<code>=A1=0,3<\/code> \"v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb FALSE\" = \"Gi\u00e1 tr\u1ecb trong \u00f4 A1 kh\u00f4ng b\u1eb1ng 0,3\"<\/strong> \u0110\u00f3 l\u00e0 \u00fd ngh\u0129a c\u1ee7a c\u00e2u n\u00e0y. H\u00e3y ghi nh\u1edb \u0111i\u1ec1u n\u00e0y khi xem v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p>\u203bDo y\u00eau c\u1ea7u v\u1ec1 c\u00e1ch tr\u00ecnh b\u00e0y, c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c ghi b\u1eb1ng d\u1ea5u b\u1eb1ng (=) to\u00e0n k\u00fd t\u1ef1. Khi nh\u1eadp v\u00e0o Excel, vui l\u00f2ng chuy\u1ec3n sang d\u1ea5u b\u1eb1ng \u201c=\u201d n\u1eeda k\u00fd t\u1ef1.<\/p>\n<h3>V\u00ed d\u1ee5 1\uff5cB\u00ed \u1ea9n c\u1ee7a ph\u00e9p t\u00ednh 0,1 + 0,2 \u2260 0,3<\/h3>\n<p>H\u00e3y th\u1eed nh\u1eadp n\u1ed9i dung sau v\u00e0o \u00f4 trong Excel<\/p>\n<table>\n<thead>\n<tr>\n<th>\u00d4<\/th>\n<th>C\u00f4ng th\u1ee9c to\u00e1n h\u1ecdc<\/th>\n<th>K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb<\/th>\n<th>Gi\u00e1 tr\u1ecb b\u00ean trong<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>A1<\/td>\n<td><code>= 0,1 + 0,2<\/code><\/td>\n<td><strong>0.3<\/strong><\/td>\n<td>0,30000000000000004\u2026<\/td>\n<\/tr>\n<tr>\n<td>A2<\/td>\n<td><code>=A1=0,3<\/code><\/td>\n<td><strong>FALSE<\/strong><\/td>\n<td>(N\u00f3i ch\u00ednh x\u00e1c th\u00ec kh\u00f4ng ho\u00e0n to\u00e0n gi\u1ed1ng nhau)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>M\u1eb7c d\u00f9 gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb l\u00e0 \u201c0,3\u201d \u0111\u00fang, nh\u01b0ng,<code>=A1=0,3<\/code> Khi so s\u00e1nh th\u00ec <strong>Tr\u1edf th\u00e0nh FALSE<\/strong>. \u0110\u00e2y ch\u00ednh l\u00e0 \u201ct\u00ednh c\u00e1ch\u201d c\u1ee7a ti\u00eau chu\u1ea9n IEEE 754 \u0111\u00f3 www<\/p>\n<p>Th\u1eadt l\u00e0 b\u1ef1c m\u00ecnh nh\u1ec9 w<\/p>\n<h3>V\u00ed d\u1ee5 2\uff5cKhi c\u1ed9ng th\u00eam 100, k\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng c\u00f2n l\u00e0 s\u1ed1 nguy\u00ean<\/h3>\n<p><code>=SUM(A1:A100)<\/code> Khi c\u1ed9ng t\u1ed5ng nhi\u1ec1u \u00f4 nh\u01b0 v\u1eady, sai s\u1ed1 nh\u1ecf trong t\u1eebng \u00f4 s\u1ebd<strong>X\u1ebfp ch\u1ed3ng l\u00ean nhau th\u00e0nh 100 c\u00e1i<\/strong>\uff1a<\/p>\n<ul>\n<li>C\u1ed9ng t\u1eebng s\u1ed1 0,1 \u00d7 100 m\u1ed9t c\u00e1ch ri\u00eang l\u1ebb \u2192 K\u1ebft qu\u1ea3 l\u00e0 9,99999999999998\u2026<\/li>\n<li>Gi\u00e1 tr\u1ecb k\u1ef3 v\u1ecdng c\u1ee7a <strong>10<\/strong> c\u00f3 th\u1ec3 kh\u00f4ng ho\u00e0n to\u00e0n kh\u1edbp<\/li>\n<\/ul>\n<p>Trong vi\u1ec7c t\u1ed5ng h\u1ee3p kh\u1ed1i l\u01b0\u1ee3ng c\u00f4ng tr\u00ecnh x\u00e2y d\u1ef1ng <strong>T\u1ed5ng h\u1ee3p 100 d\u00f2ng theo c\u00f4ng th\u1ee9c \u201cdi\u1ec7n t\u00edch \u00d7 \u0111\u01a1n gi\u00e1\u201d<\/strong> Khi th\u1ef1c hi\u1ec7n nh\u01b0 v\u1eady, \u1edf d\u00f2ng cu\u1ed1i c\u00f9ng s\u1ebd l\u00e0 <strong>S\u1ef1 ch\u00eanh l\u1ec7ch t\u1eeb v\u00e0i y\u00ean \u0111\u1ebfn v\u00e0i ch\u1ee5c y\u00ean<\/strong> \u0110\u00f3 l\u00e0 l\u00fd do t\u1ea1i sao \u0111i\u1ec1u n\u00e0y x\u1ea3y ra.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-65953\" src=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/cb7803b0943e6f4fc8097624033210ff.jpg\" alt=\"V\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c c\u00e1c s\u1ed1 th\u1eadp ph\u00e2n t\u00edch l\u0169y v\u00e0 l\u00e0m sai l\u1ec7ch k\u1ebft qu\u1ea3 so v\u1edbi s\u1ed1 nguy\u00ean khi t\u00ednh t\u1ed5ng 100 \u00f4 trong Excel | L\u1ed7i \u0111i\u1ec3n h\u00ecnh khi t\u1ed5ng h\u1ee3p s\u1ed1 l\u01b0\u1ee3ng]\" width=\"600\" height=\"338\" \/><\/p>\n<h3>V\u00ed d\u1ee5 3 | T\u00edch l\u0169y s\u1ed1 th\u1eadp ph\u00e2n khi t\u00ednh di\u1ec7n t\u00edch m\u1eb7t d\u1ed1c (T\u00ecnh hu\u1ed1ng th\u01b0\u1eddng g\u1eb7p t\u1ea1i c\u00f4ng tr\u01b0\u1eddng x\u00e2y d\u1ef1ng m\u1eb7t d\u1ed1c)<\/h3>\n<p>C\u00e1c tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3 th\u01b0\u1eddng hay x\u1ea3y ra khi t\u00ednh to\u00e1n di\u1ec7n t\u00edch c\u00f4ng tr\u00ecnh gia c\u1ed1 taluy:<\/p>\n<ul>\n<li>K\u1ef9 thu\u1eadt khung ph\u00e1p l\u00fd:<strong>S\u1eed d\u1ee5ng h\u00e0m c\u0103n b\u1eadc hai trong Excel \u0111\u1ec3 t\u00ednh di\u1ec7n t\u00edch, sau \u0111\u00f3 c\u1ed9ng c\u00e1c di\u1ec7n t\u00edch \u0111\u00f3 l\u1ea1i v\u1edbi nhau<\/strong><\/li>\n<li>\u1ede d\u00f2ng SUM cu\u1ed1i c\u00f9ng, so s\u00e1nh v\u1edbi k\u1ebft qu\u1ea3 t\u00ednh b\u1eb1ng tay v\u00e0 <strong>S\u1ef1 ch\u00eanh l\u1ec7ch t\u1eeb 0,1 \u0111\u1ebfn 0,5 m\u00b2<\/strong><\/li>\n<\/ul>\n<p>\u0110\u00e2y l\u00e0 tr\u01b0\u1eddng h\u1ee3p m\u1ea5t c\u1ea3 n\u1eeda ng\u00e0y m\u00e0 v\u1eabn kh\u00f4ng t\u00ecm ra nguy\u00ean nh\u00e2n.<\/p>\n<p>T\u00f4i c\u00f2n nh\u1edb h\u1ed3i x\u01b0a m\u00ecnh \u0111\u00e3 d\u00f9ng c\u00e1i n\u00e0y \u0111\u1ec3 t\u00ednh to\u00e1n \u0111i t\u00ednh to\u00e1n l\u1ea1i bi\u1ebft bao l\u1ea7n! w<\/p>\n<h2>Gi\u1ea3i ph\u00e1p thay th\u1ebf | L\u00e0m tr\u00f2n t\u1eebng l\u1ea7n b\u1eb1ng h\u00e0m ROUND<\/h2>\n<h3>Ch\u1ec9 \u201cgi\u1ea3m s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n\u201d trong c\u00e0i \u0111\u1eb7t \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb l\u00e0 ch\u01b0a \u0111\u1ee7<\/h3>\n<p>C\u00e1ch gi\u1ea3m s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n trong t\u00ednh n\u0103ng \u201c\u0110\u1ecbnh d\u1ea1ng \u00f4\u201d c\u1ee7a Excel l\u00e0,<\/p>\n<p><strong>Ch\u1ec9 l\u00e0m tr\u00f2n s\u1ed1 hi\u1ec3n th\u1ecb, c\u00f2n gi\u00e1 tr\u1ecb th\u1ef1c b\u00ean trong v\u1eabn c\u00f2n sai s\u1ed1<\/strong>\u3002<\/p>\n<p>N\u1ebfu chuy\u1ec3n sang ph\u00e9p t\u00ednh ti\u1ebfp theo, sai s\u1ed1 v\u1eabn c\u00f2n t\u1ed3n t\u1ea1i, do \u0111\u00f3 \u0111\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 gi\u1ea3i ph\u00e1p tri\u1ec7t \u0111\u1ec3.<\/p>\n<p><strong>Gi\u1ea3i ph\u00e1p th\u1ef1c s\u1ef1 l\u00e0 l\u00e0m tr\u00f2n ch\u00ednh gi\u00e1 tr\u1ecb \u0111\u00f3 trong h\u00e0m<\/strong>.<\/p>\n<h3>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUND t\u00f9y theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p<\/h3>\n<table>\n<thead>\n<tr>\n<th>H\u00e0m<\/th>\n<th>Ho\u1ea1t \u0111\u1ed9ng<\/th>\n<th>M\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><code>=ROUND(gi\u00e1 tr\u1ecb, s\u1ed1 ch\u1eef s\u1ed1)<\/code><\/td>\n<td>L\u00e0m tr\u00f2n<\/td>\n<td><strong>M\u1ee5c \u0111\u00edch chung\u30fbT\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n<\/strong><\/td>\n<\/tr>\n<tr>\n<td><code>=ROUNDDOWN(gi\u00e1 tr\u1ecb, s\u1ed1 ch\u1eef s\u1ed1)<\/code><\/td>\n<td>C\u1eaft b\u1ecf<\/td>\n<td>T\u00ednh to\u00e1n d\u1ef1 ph\u00f2ng theo h\u01b0\u1edbng an to\u00e0n<\/td>\n<\/tr>\n<tr>\n<td><code>=ROUNDUP(gi\u00e1 tr\u1ecb, s\u1ed1 ch\u1eef s\u1ed1)<\/code><\/td>\n<td>L\u00e0m tr\u00f2n l\u00ean<\/td>\n<td>S\u1ed1 l\u01b0\u1ee3ng \u0111\u1eb7t h\u00e0ng nguy\u00ean v\u1eadt li\u1ec7u (\u0111\u1ec3 tr\u00e1nh t\u00ecnh tr\u1ea1ng thi\u1ebfu h\u1ee5t)<\/td>\n<\/tr>\n<tr>\n<td><code>=INT(gi\u00e1 tr\u1ecb)<\/code><\/td>\n<td>L\u1ea5y gi\u00e1 tr\u1ecb nguy\u00ean (s\u1ed1 \u00e2m l\u00e0 h\u00e0m s\u00e0n)<\/td>\n<td>N\u1ebfu mu\u1ed1n gi\u1edbi h\u1ea1n \u1edf c\u00e1c gi\u00e1 tr\u1ecb nguy\u00ean<\/td>\n<\/tr>\n<tr>\n<td><code>=FLOOR(gi\u00e1 tr\u1ecb, \u0111\u01a1n v\u1ecb)<\/code><\/td>\n<td>L\u00e0m tr\u00f2n xu\u1ed1ng theo \u0111\u01a1n v\u1ecb quy \u0111\u1ecbnh<\/td>\n<td>L\u00e0m tr\u00f2n theo \u0111\u01a1n v\u1ecb 10 y\u00ean v\u00e0 100 y\u00ean<\/td>\n<\/tr>\n<tr>\n<td><code>=CEILING(gi\u00e1 tr\u1ecb, \u0111\u01a1n v\u1ecb)<\/code><\/td>\n<td>L\u00e0m tr\u00f2n l\u00ean theo \u0111\u01a1n v\u1ecb quy \u0111\u1ecbnh<\/td>\n<td>Nh\u01b0 tr\u00ean, \u0111\u1ec3 tr\u00e1nh thi\u1ebfu h\u1ee5t<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-65956\" src=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/498232aff69a45c619c4f175a977c15a.jpg\" alt=\"C\u00e1ch l\u00e0m \u0111\u00fang \u0111\u1ec3 l\u00e0m tr\u00f2n v\u00e0 lo\u1ea1i b\u1ecf ph\u1ea7n th\u1eadp ph\u00e2n b\u1eb1ng h\u00e0m ROUND | C\u00e1c b\u01b0\u1edbc t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n\" width=\"600\" height=\"338\" \/><\/p>\n<h3>Khi l\u1eadp d\u1ef1 to\u00e1n hay t\u00ednh to\u00e1n s\u01a1 b\u1ed9, nh\u1ea5t \u0111\u1ecbnh ph\u1ea3i l\u00e0m nh\u01b0 th\u1ebf n\u00e0y!<\/h3>\n<p>Quy tr\u00ecnh t\u00ednh to\u00e1n v\u00e0 \u01b0\u1edbc t\u00ednh chi ph\u00ed c\u00f4ng tr\u00ecnh m\u00e0 t\u00f4i \u0111ang th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n lu\u00f4n lu\u00f4n <code>=ROUND(s\u1ed1 l\u01b0\u1ee3ng * \u0111\u01a1n gi\u00e1 * 1,10, 0)<\/code><\/strong> v\u00e0 l\u00e0m tr\u00f2n theo \u0111\u01a1n v\u1ecb y\u00ean m\u1ed7i l\u1ea7n<\/li>\n<li><strong>T\u00ednh to\u00e1n s\u1ed1 l\u01b0\u1ee3ng (di\u1ec7n t\u00edch, th\u1ec3 t\u00edch) l\u00e0 <code>=ROUND(gi\u00e1 tr\u1ecb, 2)<\/code> v\u00e0 \u0111\u1ebfn 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n<\/strong> Cu\u1ed9n l\u1ea1i v\u00e0 c\u1ed1 \u0111\u1ecbnh<\/li>\n<li><strong>Kh\u00f4ng t\u00ednh l\u1ea1i \u1edf d\u00f2ng cu\u1ed1i c\u00f9ng c\u1ee7a b\u1ea3ng t\u1ed5ng h\u1ee3p<\/strong>(T\u1ed5ng \u0111\u01a1n gi\u1ea3n c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e3 l\u00e0m tr\u00f2n trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n)<\/li>\n<\/ul>\n<p>Nh\u1edd v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 l\u1eadp \u0111\u01b0\u1ee3c b\u1ea3ng t\u00ednh kh\u00f4ng ch\u00eanh l\u1ec7ch d\u00f9 ch\u1ec9 1 y\u00ean so v\u1edbi k\u1ebft qu\u1ea3 t\u00ednh b\u1eb1ng tay.<\/p>\n<h2>C\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi \u201cT\u00f9y ch\u1ecdn \u0111\u1ed9 ch\u00ednh x\u00e1c t\u00ednh to\u00e1n c\u1ee7a Excel\u201d<\/h2>\n<p>Trong Excel c\u00f3 <strong>T\u00f9y ch\u1ecdn \u201cT\u00ednh to\u00e1n d\u1ef1a tr\u00ean s\u1ed1 ch\u1eef s\u1ed1 hi\u1ec3n th\u1ecb\u201d<\/strong>C\u0169ng c\u00f3 t\u00f9y ch\u1ecdn n\u00e0y (T\u1ec7p \u2192 T\u00f9y ch\u1ecdn \u2192 C\u00e0i \u0111\u1eb7t n\u00e2ng cao \u2192 Khi t\u00ednh to\u00e1n s\u1ed5 l\u00e0m vi\u1ec7c n\u00e0y).<\/p>\n<p>Khi b\u1eadt t\u00ednh n\u0103ng n\u00e0y,<strong>T\u00ednh to\u00e1n v\u00e0 l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb b\u00ean trong theo \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb c\u1ee7a \u00f4<\/strong>H\u1ecd s\u1ebd l\u00e0m \u0111i\u1ec1u \u0111\u00f3. Tuy nhi\u00ean,<\/p>\n<ul>\n<li>\u00c1p d\u1ee5ng cho to\u00e0n b\u1ed9 cu\u1ed1n s\u00e1ch (kh\u00f4ng th\u1ec3 \u00e1p d\u1ee5ng t\u1eebng ph\u1ea7n)<\/li>\n<li>K\u1ebft qu\u1ea3 t\u00ednh to\u00e1n hi\u1ec7n t\u1ea1i c\u00f3 kh\u1ea3 n\u0103ng s\u1ebd thay \u0111\u1ed5i ho\u00e0n to\u00e0n<\/li>\n<li><strong>T\u1ed1t nh\u1ea5t l\u00e0 kh\u00f4ng n\u00ean s\u1eed d\u1ee5ng trong b\u1ea3n d\u1ef1 to\u00e1n \u0111\u01b0\u1ee3c chia s\u1ebb trong nh\u00f3m<\/strong><\/li>\n<\/ul>\n<p>N\u00f3i th\u1eb3ng ra, tr\u00ean th\u1ef1c t\u1ebf th\u00ec ch\u00fang ta s\u1ebd kh\u00f4ng s\u1eed d\u1ee5ng t\u00f9y ch\u1ecdn n\u00e0y,<strong>S\u1eed d\u1ee5ng h\u00e0m ROUND \u0111\u1ec3 \u0111i\u1ec1u khi\u1ec3n t\u1eebng tr\u01b0\u1eddng h\u1ee3p ri\u00eang l\u1ebb s\u1ebd an to\u00e0n h\u01a1n<\/strong>\u0110\u00e2y l\u00e0 l\u1ef1a ch\u1ecdn \u0111\u01b0\u1ee3c khuy\u00ean d\u00f9ng.<\/p>\n<h2>Kh\u00f4ng ch\u1ec9 ri\u00eang Excel\uff5cGi\u1edbi h\u1ea1n c\u1ee7a ti\u00eau chu\u1ea9n IEEE 754<\/h2>\n<p>Sai s\u1ed1 s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng theo ti\u00eau chu\u1ea9n IEEE 754 l\u00e0,<strong>\u0110\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 v\u1ea5n \u0111\u1ec1 ri\u00eang c\u1ee7a Excel, m\u00e0 l\u00e0 v\u1ea5n \u0111\u1ec1 x\u1ea3y ra tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh ch\u00ednh nh\u01b0 Google Spreadsheet, Numbers, OpenOffice, v.v.<\/strong>S\u1ebd l\u00e0m.<\/p>\n<p>H\u01a1n n\u1eefa, h\u1ea7u h\u1ebft c\u00e1c ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh nh\u01b0 C, Python, JavaScript, SQL\u2026 c\u0169ng \u0111\u1ec1u tu\u00e2n theo c\u00f9ng m\u1ed9t ti\u00eau chu\u1ea9n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-65958\" src=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/221f7225f9f401a8cf2431001ad9c2fc.jpg\" alt=\"IEEE 754 l\u00e0 ti\u00eau chu\u1ea9n chung cho t\u1ea5t c\u1ea3 c\u00e1c ph\u1ea7n m\u1ec1m b\u1ea3ng t\u00ednh v\u00e0 ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh ngo\u1ea1i tr\u1eeb Excel | Sai s\u1ed1 \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh th\u1ed1ng nh\u1ea5t tr\u00ean to\u00e0n th\u1ebf gi\u1edbi\" width=\"600\" height=\"338\" \/><\/p>\n<p>N\u00f3i c\u00e1ch kh\u00e1c,<strong>Kh\u00f4ng ph\u1ea3i l\u00e0 \u201cv\u00ec d\u00f9ng Excel n\u00ean kh\u00f4ng ch\u00ednh x\u00e1c\u201d, m\u00e0 l\u00e0 ti\u00eau chu\u1ea9n chung tr\u00ean to\u00e0n th\u1ebf gi\u1edbi<\/strong>. V\u1edbi t\u01b0 c\u00e1ch l\u00e0 m\u1ed9t k\u1ef9 s\u01b0 x\u00e2y d\u1ef1ng, vi\u1ec7c hi\u1ec3u \u0111i\u1ec1u \u0111\u00f3 v\u00e0 s\u1eed d\u1ee5ng h\u00e0m ROUND m\u1edbi l\u00e0 c\u00e1ch gi\u1ea3i \u0111\u00fang.<\/p>\n<h2>5 \u0111i\u1ec3m c\u1ea7n l\u01b0u \u00fd<\/h2>\n<p>Khi s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh di\u1ec7n t\u00edch, t\u00ednh s\u1ed1 l\u01b0\u1ee3ng, v.v., h\u00e3y l\u01b0u \u00fd 5 \u0111i\u1ec3m sau \u0111\u00e2y.<\/p>\n<ul>\n<li>\u2705 <strong>Vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n lu\u00f4n lu\u00f4n <code>=ROUND(\u2026,0)<\/code><\/strong> v\u00e0 l\u00e0m tr\u00f2n \u0111\u1ebfn \u0111\u01a1n v\u1ecb y\u00ean<\/li>\n<li>\u2705 <strong>Vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 l\u01b0\u1ee3ng l\u00e0 <code>=ROUND(\u2026,2)<\/code><\/strong> v\u00e0 c\u1ed1 \u0111\u1ecbnh 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n<\/li>\n<li>\u2705 <strong>Vi\u1ec7c l\u00e0m tr\u00f2n trong \u0111\u1ecbnh d\u1ea1ng hi\u1ec3n th\u1ecb kh\u00f4ng l\u00e0m thay \u0111\u1ed5i gi\u00e1 tr\u1ecb b\u00ean trong<\/strong>C\u00f3 \u00fd th\u1ee9c v\u1ec1 \u0111i\u1ec1u \u0111\u00f3<\/li>\n<li>\u2705 <strong><code>=A1=0,3<\/code> Tr\u00e1nh so s\u00e1nh tr\u1ef1c ti\u1ebfp nh\u01b0 v\u1eady<\/strong>(C\u00e1i b\u1eaby c\u1ee7a k\u1ebft qu\u1ea3 FALSE)<\/li>\n<li>\u2705 <strong>Trong b\u1ea3ng t\u00ednh t\u1ed5ng chi ph\u00ed d\u00f9ng cho nh\u00f3m, kh\u00f4ng s\u1eed d\u1ee5ng \u201ct\u00f9y ch\u1ecdn \u0111\u1ed9 ch\u00ednh x\u00e1c\u201d<\/strong><\/li>\n<\/ul>\n<hr \/>\n<p>N\u1ebfu b\u1ea1n c\u00f2n b\u0103n kho\u0103n, tr\u01b0\u1edbc ti\u00ean h\u00e3y c\u00e2n nh\u1eafc xem \u201cc\u00f3 n\u00ean ch\u00e8n th\u00eam m\u1ed9t b\u01b0\u1edbc h\u00e0m ROUND hay kh\u00f4ng\u201d.<\/p>\n<p>Ch\u1ec9 c\u1ea7n ch\u00e8n th\u00eam 1 v\u00f2ng l\u1eb7p (ROUND) l\u00e0 sai s\u1ed1 do ti\u00eau chu\u1ea9n IEEE 754 g\u00e2y ra s\u1ebd bi\u1ebfn m\u1ea5t ho\u00e0n to\u00e0n.<\/p>\n<p>Kh\u00f4ng ph\u1ea3i l\u00e0 Excel c\u00f3 \u201cth\u00f3i quen\u201d, m\u00e0 l\u00e0,<strong>Nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m ri\u00eang c\u1ee7a ph\u00e9p t\u00ednh s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng tr\u00ean th\u1ebf gi\u1edbi<\/strong>Ch\u00fang ta c\u1ea7n hi\u1ec3u r\u00f5 v\u00e0 v\u1eadn d\u1ee5ng th\u00e0nh th\u1ea1o \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<p>&nbsp;<\/p>\n<p>H\u1eb9n g\u1eb7p l\u1ea1i nh\u00e9.<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"jNHHIOe3aM\"><p><a href=\"https:\/\/norimen.net\/vi\/loi-sap-xep-chi-co-mot-dap-an-dung\/\">M\u1eb7c d\u00f9 c\u00f3 nhi\u1ec1u \u00fd ki\u1ebfn \u0111\u1eb7t c\u00e2u h\u1ecfi v\u1ec1 s\u1ef1 c\u1ea7n thi\u1ebft c\u1ee7a sai s\u1ed1 b\u1ed1 tr\u00ed trong qu\u00e1 tr\u00ecnh \u0111\u1ed5 b\u00ea t\u00f4ng, nh\u01b0ng c\u00e2u tr\u1ea3 l\u1eddi lu\u00f4n ch\u1ec9 c\u00f3 m\u1ed9t!<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cM\u1eb7c d\u00f9 c\u00f3 nhi\u1ec1u \u00fd ki\u1ebfn \u0111\u1eb7t c\u00e2u h\u1ecfi v\u1ec1 s\u1ef1 c\u1ea7n thi\u1ebft c\u1ee7a sai s\u1ed1 b\u1ed1 tr\u00ed trong qu\u00e1 tr\u00ecnh \u0111\u1ed5 b\u00ea t\u00f4ng, nh\u01b0ng c\u00e2u tr\u1ea3 l\u1eddi lu\u00f4n ch\u1ec9 c\u00f3 m\u1ed9t!\u201d \u2014 Kh\u00f3a h\u1ecdc Qu\u1ea3n l\u00fd m\u1eb7t d\u1ed1c c\u1ee7a Shin-Enta\" src=\"https:\/\/norimen.net\/placement-error-only-one-answer\/embed\/#?secret=xXGJcLD6Dc#?secret=jNHHIOe3aM\" data-secret=\"jNHHIOe3aM\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>","protected":false},"excerpt":{"rendered":"<p>Xin ch\u00e0o m\u1ecdi ng\u01b0\u1eddi. T\u00f4i l\u00e0 Enta. C\u00e1c b\u1ea1n c\u00f3 bao gi\u1edd g\u1eb7p tr\u01b0\u1eddng h\u1ee3p \u0111ang t\u1ed5ng h\u1ee3p s\u1ed1 l\u01b0\u1ee3ng tr\u00ean Excel m\u00e0 ph\u00e1t hi\u1ec7n ra r\u1eb1ng \u201ckhi c\u1ed9ng t\u1ea5t c\u1ea3 l\u1ea1i, k\u1ebft qu\u1ea3 ch\u00eanh l\u1ec7ch 1 y\u00ean so v\u1edbi t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng\u201d kh\u00f4ng? Ngay c\u1ea3 trong vi\u1ec7c t\u00ednh to\u00e1n kh\u1ed1i l\u01b0\u1ee3ng c\u00f4ng tr\u00ecnh gia c\u1ed1 taluy, khi \u00e1p d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c li\u00ean ti\u1ebfp nh\u01b0 di\u1ec7n t\u00edch \u00d7 \u0111\u01a1n gi\u00e1 \u00d7 thu\u1ebf ti\u00eau d\u00f9ng, hi\u1ec7n t\u01b0\u1ee3ng ch\u00eanh l\u1ec7ch 1 y\u00ean ho\u1eb7c 1 m\u00b2 \u1edf d\u00f2ng cu\u1ed1i c\u00f9ng lu\u00f4n x\u1ea3y ra. \u0110i\u1ec1u n\u00e0y\u2026<\/p>","protected":false},"author":2,"featured_media":65955,"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":[14271,32],"tags":[79,1220,14422,14423],"class_list":["post-65969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-construction-industry-3","category-documentation","tag-excel","tag-1220","tag-ieee-754","tag-round"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.3 (Yoast SEO v28.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71 - \u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e<\/title>\n<meta name=\"description\" content=\"\u30a8\u30af\u30bb\u30eb\u3067\u6570\u91cf\u96c6\u8a08\u3084\u91d1\u984d\u8a08\u7b97\u3092\u3059\u308b\u3068\u624b\u8a08\u7b97\u30681\u5186\u30ba\u30ec\u308b\u73fe\u8c61\u306e\u6b63\u4f53\u306f\u3001IEEE 754\u4ed5\u69d8\u306b\u3088\u308b\u6d6e\u52d5\u5c0f\u6570\u70b9\u6f14\u7b97\u306e\u4e38\u3081\u8aa4\u5dee\u3067\u3059\u3002Microsoft\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u5f15\u304d\u306a\u304c\u3089\u30010.1+0.2\u22600.3\u306e\u8b0e\u3001ROUND\/ROUNDDOWN\/ROUNDUP\u95a2\u6570\u306e\u4f7f\u3044\u5206\u3051\u3001\u6cd5\u9762\u7a4d\u7b97\u3067\u306e\u5b9f\u8df5\u30d1\u30bf\u30fc\u30f3\u307e\u3067\u571f\u6728\u5c4b\u304c\u89e3\u8aac\u3057\u307e\u3059\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\/vi\/loi-lam-tron-trong-excel-so-thap-phan-noi-ieee-754\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71\" \/>\n<meta property=\"og:description\" content=\"\u30a8\u30af\u30bb\u30eb\u3067\u6570\u91cf\u96c6\u8a08\u3084\u91d1\u984d\u8a08\u7b97\u3092\u3059\u308b\u3068\u624b\u8a08\u7b97\u30681\u5186\u30ba\u30ec\u308b\u73fe\u8c61\u306e\u6b63\u4f53\u306f\u3001IEEE 754\u4ed5\u69d8\u306b\u3088\u308b\u6d6e\u52d5\u5c0f\u6570\u70b9\u6f14\u7b97\u306e\u4e38\u3081\u8aa4\u5dee\u3067\u3059\u3002Microsoft\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u5f15\u304d\u306a\u304c\u3089\u30010.1+0.2\u22600.3\u306e\u8b0e\u3001ROUND\/ROUNDDOWN\/ROUNDUP\u95a2\u6570\u306e\u4f7f\u3044\u5206\u3051\u3001\u6cd5\u9762\u7a4d\u7b97\u3067\u306e\u5b9f\u8df5\u30d1\u30bf\u30fc\u30f3\u307e\u3067\u571f\u6728\u5c4b\u304c\u89e3\u8aac\u3057\u307e\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/norimen.net\/vi\/loi-lam-tron-trong-excel-so-thap-phan-noi-ieee-754\/\" \/>\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=\"2026-07-04T23:00:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/3759bace8848c3a9a850048568abdf8a.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"338\" \/>\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=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u30a8\u30f3\u30bf\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/\"},\"author\":{\"name\":\"\u30a8\u30f3\u30bf\",\"@id\":\"https:\\\/\\\/norimen.net\\\/#\\\/schema\\\/person\\\/7e507d48b040ed0f7a88ef4625070b95\"},\"headline\":\"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71\",\"datePublished\":\"2026-07-04T23:00:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/\"},\"wordCount\":75,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/3759bace8848c3a9a850048568abdf8a.jpg\",\"keywords\":[\"Excel\",\"\u6570\u91cf\u8a08\u7b97\",\"IEEE 754\",\"ROUND\u95a2\u6570\"],\"articleSection\":[\"\u5efa\u8a2d\u696d\u5168\u4f53\u306e\u8a71\u3057\",\"\u66f8\u985e\u6574\u7406\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/\",\"url\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/\",\"name\":\"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71 - \u65b0\u30a8\u30f3\u30bf\u306e\u6cd5\u9762\u7ba1\u7406\u587e\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/3759bace8848c3a9a850048568abdf8a.jpg\",\"datePublished\":\"2026-07-04T23:00:39+00:00\",\"description\":\"\u30a8\u30af\u30bb\u30eb\u3067\u6570\u91cf\u96c6\u8a08\u3084\u91d1\u984d\u8a08\u7b97\u3092\u3059\u308b\u3068\u624b\u8a08\u7b97\u30681\u5186\u30ba\u30ec\u308b\u73fe\u8c61\u306e\u6b63\u4f53\u306f\u3001IEEE 754\u4ed5\u69d8\u306b\u3088\u308b\u6d6e\u52d5\u5c0f\u6570\u70b9\u6f14\u7b97\u306e\u4e38\u3081\u8aa4\u5dee\u3067\u3059\u3002Microsoft\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u5f15\u304d\u306a\u304c\u3089\u30010.1+0.2\u22600.3\u306e\u8b0e\u3001ROUND\\\/ROUNDDOWN\\\/ROUNDUP\u95a2\u6570\u306e\u4f7f\u3044\u5206\u3051\u3001\u6cd5\u9762\u7a4d\u7b97\u3067\u306e\u5b9f\u8df5\u30d1\u30bf\u30fc\u30f3\u307e\u3067\u571f\u6728\u5c4b\u304c\u89e3\u8aac\u3057\u307e\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#primaryimage\",\"url\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/3759bace8848c3a9a850048568abdf8a.jpg\",\"contentUrl\":\"https:\\\/\\\/norimen.net\\\/wordpress\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/3759bace8848c3a9a850048568abdf8a.jpg\",\"width\":600,\"height\":338,\"caption\":\"\u30a8\u30af\u30bb\u30eb\u7aef\u6570\u84c4\u7a4d\u8aa4\u5dee\u306e\u6b63\u4f53\u306fIEEE 754\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#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\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71\"}]},{\"@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\":\"vi\"},{\"@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-ieee754-floating-point\\\/#local-main-organization-logo\"},\"image\":{\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#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\":\"vi\",\"@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\":\"vi\",\"@id\":\"https:\\\/\\\/norimen.net\\\/excel-rounding-error-ieee754-floating-point\\\/#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":"Nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m ri\u00eang c\u1ee7a Excel | L\u00fd do k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n b\u1ecb sai l\u1ec7ch do t\u00edch l\u0169y s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 ti\u00eau chu\u1ea9n IEEE 754 - L\u1edbp h\u1ecdc qu\u1ea3n l\u00fd m\u1eb7t d\u1ed1c c\u1ee7a Shin-Ent","description":"Nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn hi\u1ec7n t\u01b0\u1ee3ng t\u1ed5ng h\u1ee3p s\u1ed1 l\u01b0\u1ee3ng ho\u1eb7c t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n trong Excel b\u1ecb ch\u00eanh l\u1ec7ch 1 y\u00ean so v\u1edbi t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng ch\u00ednh l\u00e0 sai s\u1ed1 l\u00e0m tr\u00f2n trong ph\u00e9p t\u00ednh s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng theo ti\u00eau chu\u1ea9n IEEE 754. D\u1ef1a tr\u00ean t\u00e0i li\u1ec7u ch\u00ednh th\u1ee9c c\u1ee7a Microsoft, m\u1ed9t chuy\u00ean gia trong l\u0129nh v\u1ef1c x\u00e2y d\u1ef1ng s\u1ebd gi\u1ea3i th\u00edch v\u1ec1 b\u00ed \u1ea9n \u201c0,1 + 0,2 \u2260 0,3\u201d, c\u00e1ch ph\u00e2n bi\u1ec7t v\u00e0 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m ROUND\/ROUNDDOWN\/ROUNDUP, c\u0169ng nh\u01b0 c\u00e1c m\u1eabu \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf trong t\u00ednh to\u00e1n di\u1ec7n t\u00edch.","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\/vi\/loi-lam-tron-trong-excel-so-thap-phan-noi-ieee-754\/","og_locale":"vi_VN","og_type":"article","og_title":"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71","og_description":"\u30a8\u30af\u30bb\u30eb\u3067\u6570\u91cf\u96c6\u8a08\u3084\u91d1\u984d\u8a08\u7b97\u3092\u3059\u308b\u3068\u624b\u8a08\u7b97\u30681\u5186\u30ba\u30ec\u308b\u73fe\u8c61\u306e\u6b63\u4f53\u306f\u3001IEEE 754\u4ed5\u69d8\u306b\u3088\u308b\u6d6e\u52d5\u5c0f\u6570\u70b9\u6f14\u7b97\u306e\u4e38\u3081\u8aa4\u5dee\u3067\u3059\u3002Microsoft\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u5f15\u304d\u306a\u304c\u3089\u30010.1+0.2\u22600.3\u306e\u8b0e\u3001ROUND\/ROUNDDOWN\/ROUNDUP\u95a2\u6570\u306e\u4f7f\u3044\u5206\u3051\u3001\u6cd5\u9762\u7a4d\u7b97\u3067\u306e\u5b9f\u8df5\u30d1\u30bf\u30fc\u30f3\u307e\u3067\u571f\u6728\u5c4b\u304c\u89e3\u8aac\u3057\u307e\u3059\u3002","og_url":"https:\/\/norimen.net\/vi\/loi-lam-tron-trong-excel-so-thap-phan-noi-ieee-754\/","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":"2026-07-04T23:00:39+00:00","og_image":[{"width":600,"height":338,"url":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/3759bace8848c3a9a850048568abdf8a.jpg","type":"image\/jpeg"}],"author":"\u30a8\u30f3\u30bf","twitter_card":"summary_large_image","twitter_creator":"@norimenman","twitter_site":"@norimenman","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"\u30a8\u30f3\u30bf","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"10 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#article","isPartOf":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/"},"author":{"name":"\u30a8\u30f3\u30bf","@id":"https:\/\/norimen.net\/#\/schema\/person\/7e507d48b040ed0f7a88ef4625070b95"},"headline":"\u30a8\u30af\u30bb\u30eb\u306e\u7656\uff5c\u7aef\u6570\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71","datePublished":"2026-07-04T23:00:39+00:00","mainEntityOfPage":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/"},"wordCount":75,"commentCount":0,"publisher":{"@id":"https:\/\/norimen.net\/#organization"},"image":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#primaryimage"},"thumbnailUrl":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/3759bace8848c3a9a850048568abdf8a.jpg","keywords":["Excel","\u6570\u91cf\u8a08\u7b97","IEEE 754","ROUND\u95a2\u6570"],"articleSection":["\u5efa\u8a2d\u696d\u5168\u4f53\u306e\u8a71\u3057","\u66f8\u985e\u6574\u7406"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/","url":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/","name":"Nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m ri\u00eang c\u1ee7a Excel | L\u00fd do k\u1ebft qu\u1ea3 t\u00ednh to\u00e1n b\u1ecb sai l\u1ec7ch do t\u00edch l\u0169y s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft v\u1ec1 ti\u00eau chu\u1ea9n IEEE 754 - L\u1edbp h\u1ecdc qu\u1ea3n l\u00fd m\u1eb7t d\u1ed1c c\u1ee7a Shin-Ent","isPartOf":{"@id":"https:\/\/norimen.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#primaryimage"},"image":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#primaryimage"},"thumbnailUrl":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/3759bace8848c3a9a850048568abdf8a.jpg","datePublished":"2026-07-04T23:00:39+00:00","description":"Nguy\u00ean nh\u00e2n d\u1eabn \u0111\u1ebfn hi\u1ec7n t\u01b0\u1ee3ng t\u1ed5ng h\u1ee3p s\u1ed1 l\u01b0\u1ee3ng ho\u1eb7c t\u00ednh to\u00e1n s\u1ed1 ti\u1ec1n trong Excel b\u1ecb ch\u00eanh l\u1ec7ch 1 y\u00ean so v\u1edbi t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng ch\u00ednh l\u00e0 sai s\u1ed1 l\u00e0m tr\u00f2n trong ph\u00e9p t\u00ednh s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ed9ng theo ti\u00eau chu\u1ea9n IEEE 754. D\u1ef1a tr\u00ean t\u00e0i li\u1ec7u ch\u00ednh th\u1ee9c c\u1ee7a Microsoft, m\u1ed9t chuy\u00ean gia trong l\u0129nh v\u1ef1c x\u00e2y d\u1ef1ng s\u1ebd gi\u1ea3i th\u00edch v\u1ec1 b\u00ed \u1ea9n \u201c0,1 + 0,2 \u2260 0,3\u201d, c\u00e1ch ph\u00e2n bi\u1ec7t v\u00e0 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m ROUND\/ROUNDDOWN\/ROUNDUP, c\u0169ng nh\u01b0 c\u00e1c m\u1eabu \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf trong t\u00ednh to\u00e1n di\u1ec7n t\u00edch.","breadcrumb":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#primaryimage","url":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/3759bace8848c3a9a850048568abdf8a.jpg","contentUrl":"https:\/\/norimen.net\/wordpress\/wp-content\/uploads\/2026\/06\/3759bace8848c3a9a850048568abdf8a.jpg","width":600,"height":338,"caption":"\u30a8\u30af\u30bb\u30eb\u7aef\u6570\u84c4\u7a4d\u8aa4\u5dee\u306e\u6b63\u4f53\u306fIEEE 754"},{"@type":"BreadcrumbList","@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#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\u84c4\u7a4d\u3067\u8a08\u7b97\u7d50\u679c\u304c\u305a\u308c\u308b\u7406\u7531\u3068IEEE 754\u306e\u8a71"}]},{"@type":"WebSite","@id":"https:\/\/norimen.net\/#website","url":"https:\/\/norimen.net\/","name":"Kh\u00f3a h\u1ecdc Qu\u1ea3n l\u00fd m\u1eb7t d\u1ed1c c\u1ee7a Shin-Ent","description":"D\u00e0nh cho nh\u1eefng ai th\u1ef1c s\u1ef1 mu\u1ed1n t\u00ecm hi\u1ec3u v\u1ec1 m\u1eb7t d\u1ed1c!","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":"vi"},{"@type":["Organization","Place"],"@id":"https:\/\/norimen.net\/#organization","name":"Kh\u00f3a h\u1ecdc Qu\u1ea3n l\u00fd m\u1eb7t d\u1ed1c c\u1ee7a Shin-Ent","alternateName":"\u5869\u7530\u958b\u767a\u682a\u5f0f\u4f1a\u793e","url":"https:\/\/norimen.net\/","logo":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#local-main-organization-logo"},"image":{"@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#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":"Gi\u1ea3i tr\u00ed","image":{"@type":"ImageObject","inLanguage":"vi","@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":"Sau khi l\u00e0m vi\u1ec7c t\u1ea1i m\u1ed9t c\u00f4ng ty x\u00e2y d\u1ef1ng chuy\u00ean v\u1ec1 m\u00e1i d\u1ed1c l\u1edbn, t\u00f4i \u0111\u00e3 t\u00e1ch ra ho\u1ea1t \u0111\u1ed9ng \u0111\u1ed9c l\u1eadp \u1edf tu\u1ed5i 32. V\u00ec r\u1ea3nh r\u1ed7i qu\u00e1 n\u00ean t\u00f4i \u0111\u00e3 m\u1edf m\u1ed9t blog. T\u00f4i \u0111\u00e3 chia s\u1ebb nh\u1eefng b\u00ed quy\u1ebft v\u1ec1 m\u00e1i d\u1ed1c v\u00e0 tr\u1ea3 l\u1eddi m\u1ecdi c\u00e2u h\u1ecfi c\u00f3 th\u1ec3. K\u1ebft qu\u1ea3 l\u00e0, s\u1ed1 l\u01b0\u1ee3ng y\u00eau c\u1ea7u, c\u00e2u h\u1ecfi v\u00e0 \u0111\u01a1n \u0111\u1eb7t h\u00e0ng t\u1eeb c\u00e1c nh\u00e0 th\u1ea7u chuy\u00ean v\u1ec1 m\u00e1i d\u1ed1c, nh\u00e0 th\u1ea7u ch\u00ednh v\u00e0 c\u00e1c c\u00f4ng ty x\u00e2y d\u1ef1ng t\u1ed5ng h\u1ee3p kh\u00e1c ng\u00e0y c\u00e0ng t\u0103ng l\u00ean. S\u1ed1 l\u01b0\u1ee3t xem tr\u00ean Ameblo \u0111\u00e3 t\u0103ng l\u00ean \u1edf m\u1ee9c kh\u00e1 \u1ed5n \u0111\u1ecbnh, v\u00ec v\u1eady t\u00f4i \u0111\u00e3 quy\u1ebft \u0111\u1ecbnh mua t\u00ean mi\u1ec1n ri\u00eang v\u00e0 r\u1eddi kh\u1ecfi Ameblo v\u1edbi m\u1ee5c ti\u00eau t\u1ea1o ra m\u1ed9t blog tho\u1ea3i m\u00e1i h\u01a1n. Trong t\u01b0\u01a1ng lai, t\u00f4i s\u1ebd ti\u1ebfp t\u1ee5c chia s\u1ebb t\u1ea5t c\u1ea3 c\u00e1c b\u00ed quy\u1ebft c\u1ee7a m\u00ecnh m\u1ed9t c\u00e1ch c\u1edfi m\u1edf t\u1ea1i \u0111\u00e2y. R\u1ea5t mong nh\u1eadn \u0111\u01b0\u1ee3c s\u1ef1 \u1ee7ng h\u1ed9 c\u1ee7a qu\u00fd v\u1ecb trong th\u1eddi gian t\u1edbi.","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":"vi","@id":"https:\/\/norimen.net\/excel-rounding-error-ieee754-floating-point\/#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-09-01 09:42:02","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\/2026\/06\/3759bace8848c3a9a850048568abdf8a.jpg","_links":{"self":[{"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/posts\/65969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/comments?post=65969"}],"version-history":[{"count":3,"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/posts\/65969\/revisions"}],"predecessor-version":[{"id":66078,"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/posts\/65969\/revisions\/66078"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/media\/65955"}],"wp:attachment":[{"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/media?parent=65969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/categories?post=65969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/norimen.net\/vi\/wp-json\/wp\/v2\/tags?post=65969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}