{"id":312962,"date":"2024-01-31T15:05:23","date_gmt":"2024-01-31T08:05:23","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=312962"},"modified":"2024-01-31T15:05:23","modified_gmt":"2024-01-31T08:05:23","slug":"ham-mod-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">H\u00e0m MOD trong Excel l\u00e0 m\u1ed9t h\u00e0m chia c\u01a1 b\u1ea3n \u0111\u1ec3 ng\u01b0\u1eddi t\u00ednh to\u00e1n l\u1ea5y \u0111\u01b0\u1ee3c ph\u1ea7n d\u01b0 m\u00ecnh c\u1ea7n trong k\u1ebft qu\u1ea3. N\u1ebfu b\u1ea1n ph\u1ea3i x\u1eed l\u00fd s\u1ed1 li\u1ec7u tr\u00ean b\u1ea3ng t\u00ednh h\u00e0ng ng\u00e0y th\u00ec h\u00e0m MOD n\u00e0y r\u1ea5t quan tr\u1ecdng. N\u00f3 s\u1ebd gi\u00fap b\u1ea1n ph\u00e2n t\u00edch c\u00e1c s\u1ed1 li\u1ec7u nhanh ch\u00f3ng v\u00e0 n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c. B\u1ea1n h\u00e3y tham kh\u1ea3o th\u00eam th\u00f4ng tin sau \u0111\u1ec3 bi\u1ebft c\u00e1ch d\u00f9ng h\u00e0m MOD chu\u1ea9n nh\u1ea5t.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m MOD trong Excel l\u00e0 g\u00ec? \u1ee8ng d\u1ee5ng?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong Excel v\u00e0 d\u00f9ng \u0111\u1ec3 chia v\u00e0 l\u1ea5y s\u1ed1 d\u01b0 trong k\u1ebft qu\u1ea3 ph\u00e9p chia. Ch\u1eb3ng h\u1ea1n ch\u00fang ta c\u00f3 ph\u00e9p chia l\u00e0 10 : 3 = 3,33333\u2026. Khi d\u00f9ng h\u00e0m MOD th\u00ec k\u1ebft qu\u1ea3 xu\u1ea5t hi\u1ec7n trong \u00f4 l\u00e0 3.<\/span><\/p>\n<figure id=\"attachment_312965\" aria-describedby=\"caption-attachment-312965\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-312965 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-1.jpg\" alt=\"ham-mod-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-312965\" class=\"wp-caption-text\">H\u00e0m MOD l\u00e0 h\u00e0m g\u00ec trong Excel l\u00e0 g\u00ec? \u1ee8ng d\u1ee5ng c\u1ee7a h\u00e0m n\u00e0y?<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh \u0111\u00f3, h\u00e0m chia n\u00e0y c\u00f2n \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong nhi\u1ec1u t\u00e1c v\u1ee5 trong Excel nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">L\u1ea5y s\u1ed1 d\u01b0 trong t\u1ea5t c\u1ea3 k\u1ebft qu\u1ea3 m\u00e0 b\u1ea1n ch\u1ecdn.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">X\u00e1c \u0111\u1ecbnh \u0111\u00f3 l\u00e0 ph\u00e9p chia c\u00f3 s\u1ed1 d\u01b0 hay ph\u00e9p chia h\u1ebft v\u1edbi k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 nguy\u00ean.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ph\u1ed1i h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m Excel kh\u00e1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n.<\/span><\/li>\n<\/ul>\n<h2><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m MOD trong Excel v\u00e0 chia l\u1ea5y s\u1ed1 d\u01b0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi \u0111\u00e3 t\u00ecm hi\u1ec3u s\u01a1 qua v\u1ec1 h\u00e0m MOD th\u00ec m\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u c\u00fa ph\u00e1p v\u00e0 c\u00e1ch d\u00f9ng h\u00e0m n\u00e0y nh\u01b0 sau:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p s\u1eed d\u1ee5ng h\u00e0m MOD<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p s\u1eed d\u1ee5ng h\u00e0m: <strong>=MOD(number,division)<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3, b\u1ea1n b\u1eaft bu\u1ed9c ph\u1ea3i nh\u1eadp hai gi\u00e1 tr\u1ecb sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Number: S\u1ed1 b\u1ecb chia (ph\u1ea7n t\u1eed s\u1ed1).<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Division: S\u1ed1 chia (ph\u1ea7n m\u1eabu s\u1ed1).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-312981 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-18.jpg\" alt=\"ham-mod-trong-excel-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u00fa \u00fd:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 gi\u00e1 tr\u1ecb m\u1eabu s\u1ed1 trong h\u00e0m b\u1ecf tr\u1ed1ng hay g\u00e1n gi\u00e1 tr\u1ecb b\u1eb1ng 0 th\u00ec h\u00e0m chia MOD s\u1ebd xu\u1ea5t k\u1ebft qu\u1ea3 l\u1ed7i c\u00f3 d\u1ea1ng #DIV\/0!<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 gi\u00e1 tr\u1ecb t\u1eed s\u1ed1 trong h\u00e0m b\u1ecf tr\u1ed1ng th\u00ec h\u00e0m chia MOD s\u1ebd xu\u1ea5t ra k\u1ebft qu\u1ea3 m\u1eb7c \u0111\u1ecbnh l\u00e0 0.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 s\u1ed1 nh\u1eadp v\u00e0o l\u00e0 m\u1ed9t s\u1ed1 \u00e2m (-2, -4, -5,&#8230;) th\u00ec ng\u01b0\u1eddi nh\u1eadp ph\u1ea3i \u0111i\u1ec1n th\u00eam d\u1ea5u () \u1edf b\u00ean ngo\u00e0i c\u1ee7a s\u1ed1 \u0111\u00f3, v\u00ed d\u1ee5 nh\u01b0 (-2), (-4),&#8230; N\u1ebfu kh\u00f4ng th\u00eam d\u1ea5u ngo\u1eb7c n\u00e0y th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1ecb sai.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 do h\u00e0m chia MOD xu\u1ea5t ra s\u1ebd c\u00f3 c\u00f9ng d\u1ea5u v\u1edbi ph\u1ea7n m\u1eabu s\u1ed1 (kh\u00f4ng c\u1ea7n bi\u1ebft d\u1ea5u c\u1ee7a ph\u1ea7n t\u1eed s\u1ed1).\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m chia MOD c\u00f2n \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n b\u1eb1ng nh\u1eefng s\u1ed1 h\u1ea1ng thu\u1ed9c h\u00e0m INT nh\u01b0: MOD (n, d) = n &#8211; d * INT (n\/d)<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">C\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel \u0111\u1ec3 l\u1ea5y ph\u1ea7n d\u01b0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m chia MOD chi ti\u1ebft th\u00ec m\u1ecdi ng\u01b0\u1eddi h\u00e3y xem v\u00ed d\u1ee5 nh\u01b0 h\u00ecnh sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u1ea1n c\u1ea7n nh\u1eadp ch\u00ednh x\u00e1c c\u00fa ph\u00e1p h\u00e0m MOD l\u00e0: = MOD(A3;B3) \u1edf \u00f4 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3. Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">A3: L\u00e0\u00a0 t\u1eed s\u1ed1 hay s\u1ed1 b\u1ecb chia.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">B3: L\u00e0 m\u1eabu s\u1ed1 hay s\u1ed1 chia.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"size-full wp-image-312966 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-2.jpg\" alt=\"ham-mod-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea1n b\u1ea5m Enter v\u00e0 xem k\u1ebft qu\u1ea3. K\u1ebft qu\u1ea3 n\u00e0y c\u00f3 th\u1ec3 gi\u1ea3i th\u00edch nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">\u00d4 k\u1ebft qu\u1ea3 c\u00f3 s\u1ed1 1 v\u00ec 10 : 3 = 3 v\u00e0 ph\u1ea7n d\u01b0 l\u00e0 1.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">H\u00e0m MOD c\u0169ng gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n k\u1ebft qu\u1ea3.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312967 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-3.jpg\" alt=\"ham-mod-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: B\u1ea1n b\u1ea5m gi\u1eef 1 \u00f4 vu\u00f4ng \u1edf ph\u00eda g\u00f3c ph\u1ea3i c\u1ee7a \u00f4 ch\u1ee9a k\u1ebft qu\u1ea3 \u1edf tr\u00ean. B\u1ea1n k\u00e9o chu\u1ed9t xu\u1ed1ng d\u01b0\u1edbi \u0111\u1ec3 ti\u1ebfp t\u1ee5c \u00e1p d\u1ee5ng c\u00fa ph\u00e1p h\u00e0m MOD cho c\u00e1c \u00f4 d\u01b0\u1edbi. Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 d\u00e3y k\u1ebft qu\u1ea3 cu\u1ed1i c\u00f9ng nh\u01b0 h\u00ecnh sau: Trong \u0111\u00f3:<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312968 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-4.jpg\" alt=\"ham-mod-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 \u1edf C4: \u1ede m\u1eabu s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 0 n\u00ean \u00f4 k\u1ebft qu\u1ea3 b\u1ecb l\u1ed7i d\u1ea1ng #DIV\/0!.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 \u1edf C5: \u1ede t\u1eed s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 0 n\u00ean \u00f4 k\u1ebft qu\u1ea3 c\u00f3 gi\u00e1 tr\u1ecb l\u00e0 0.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 \u1edf C6: \u1ede m\u1eabu s\u1ed1 c\u00f3 gi\u00e1 tr\u1ecb v\u1edbi d\u1ea5u \u00e2m, v\u1eady n\u00ean \u00f4 k\u1ebft qu\u1ea3 c\u0169ng ch\u1ee9a d\u1ea5u \u00e2m.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 \u1edf C7: \u1ede t\u1eed s\u1ed1 ch\u1ee9a d\u1ea5u \u00e2m n\u00ean n\u00f3 kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng k\u1ebft qu\u1ea3.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">K\u1ebft qu\u1ea3 \u1edf C8: V\u00ec gi\u00e1 tr\u1ecb m\u1eabu s\u1ed1 v\u00e0 t\u1eed s\u1ed1 \u0111\u1ec1u c\u00f3 d\u1ea5u \u00e2m n\u00ean \u00f4 k\u1ebft qu\u1ea3 ch\u1ee9a gi\u00e1 tr\u1ecb c\u00f3 c\u00f9ng d\u1ea5u \u00e2m v\u1edbi s\u1ed1 chia.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312969 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-5.jpg\" alt=\"ham-mod-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m MOD trong Excel v\u00e0 ph\u1ed1i h\u1ee3p h\u00e0m INT<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng th\u01b0\u1eddng th\u00ec ch\u00fang ta hay s\u1eed d\u1ee5ng h\u00e0m chia MOD trong b\u1ea3ng t\u00ednh Excel \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c s\u1ed1 d\u01b0 \u1edf \u00f4 k\u1ebft qu\u1ea3. Nh\u01b0ng n\u1ebfu \u1ee9ng d\u1ee5ng trong th\u1ef1c t\u1ebf th\u00ec h\u00e0m chia MOD l\u1ea1i hay d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y m\u00e0 kh\u00e1ch tr\u1ea3 ph\u00f2ng khi h\u1ecd s\u1eed d\u1ee5ng d\u1ecbch v\u1ee5 nh\u00e0 ngh\u1ec9, kh\u00e1ch s\u1ea1n\u2026 Sau \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n:\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: H\u00e3y t\u00ednh to\u00e1n s\u1ed1 ng\u00e0y m\u00e0 kh\u00e1ch ph\u1ea3i tr\u1ea3 ph\u00f2ng khi h\u1ecd d\u00f9ng d\u1ecbch v\u1ee5 kh\u00e1ch s\u1ea1n nh\u01b0 h\u00ecnh sau.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u00ednh to\u00e1n s\u1ed1 tu\u1ea7n m\u00e0 kh\u00e1ch h\u00e0ng l\u01b0u tr\u00fa \u1edf kh\u00e1ch s\u1ea1n<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">\u0110\u1ea7u ti\u00ean, b\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh s\u1ed1 tu\u1ea7n m\u00e0 kh\u00e1ch l\u01b0u tr\u00fa t\u1ea1i kh\u00e1ch s\u1ea1n c\u1ee7a m\u00ecnh. \u1ede \u0111\u00e2y ch\u00fang ta kh\u00f4ng d\u00f9ng th\u00e1ng \u0111\u1ec3 t\u00ednh to\u00e1n v\u00ec s\u1ed1 ng\u00e0y c\u1ee7a n\u00f3 kh\u00f4ng \u1ed5n \u0111\u1ecbnh. C\u00f3 th\u00e1ng th\u00ec 28 ng\u00e0y, c\u00f3 th\u00e1ng th\u00ec 29, 30, 31 ng\u00e0y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u1ede b\u01b0\u1edbc n\u00e0y, b\u1ea1n c\u1ea7n d\u00f9ng h\u00e0m INT \u0111\u1ec3 t\u00ednh s\u1ed1 tu\u1ea7n m\u00e0 kh\u00e1ch l\u01b0u tr\u00fa \u1edf kh\u00e1ch s\u1ea1n theo tu\u1ea7n. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 ch\u00fang ta ph\u1ea3i t\u00ednh t\u1eeb ng\u00e0y \u0111\u1ea7u kh\u00e1ch \u0111\u1ebfn v\u00e0 t\u00ednh \u0111\u1ebfn ng\u00e0y kh\u00e1ch s\u1ebd tr\u1ea3 ph\u00f2ng:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu l\u00e0 3 ng\u00e0y th\u00ec ch\u00fang ta t\u00ednh l\u00e0 1 tu\u1ea7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu l\u00e0 8 ng\u00e0y th\u00ec ch\u00fang ta t\u00ednh l\u00e0 2 tu\u1ea7n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu l\u00e0 20 ng\u00e0y th\u00ec ch\u00fang ta t\u00ednh l\u00e0 3 tu\u1ea7n.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m INT v\u1edbi c\u00fa ph\u00e1p n\u00e0y: =INT((B3-A3)\/7. Ch\u00fang ta c\u00f3 th\u1ec3 gi\u1ea3i th\u00edch h\u00e0m INT n\u00e0y l\u00e0 ch\u00fang ta l\u1ea5y Ng\u00e0y kh\u00e1ch \u0111i (Ng\u00e0y kh\u00e1ch tr\u1ea3 ph\u00f2ng) tr\u1eeb cho Ng\u00e0y kh\u00e1ch \u0111\u1ebfn (Ng\u00e0y kh\u00e1ch nh\u1eadn ph\u00f2ng). Ti\u1ebfp \u0111\u00f3 ch\u00fang ta l\u1ea5y k\u1ebft qu\u1ea3 n\u00e0y \u0111em chia ra cho 7 (1 tu\u1ea7n) v\u00e0 x\u00e1c \u0111\u1ecbnh kh\u00e1ch \u1edf kh\u00e1ch s\u1ea1n m\u1ea5y tu\u1ea7n.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312970 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-6.jpg\" alt=\"ham-mod-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h4><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u00ednh to\u00e1n s\u1ed1 ng\u00e0y m\u00e0 kh\u00e1ch s\u1ebd tr\u1ea3 ph\u00f2ng s\u1edbm\u00a0<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Ph\u1ea7n d\u01b0 ra c\u1ee7a ph\u00e9p chia s\u1ebd th\u1ec3 hi\u1ec7n s\u1ed1 ng\u00e0y c\u00f2n l\u1ea1i n\u1ebfu t\u00ednh t\u1edbi ng\u00e0y kh\u00e1ch tr\u1ea3 ph\u00f2ng. \u1ede b\u01b0\u1edbc n\u00e0y, ch\u00fang ta d\u00f9ng h\u00e0m MOD trong Excel \u0111\u1ec3 t\u00ednh to\u00e1n th\u1eddi gian t\u1eeb khi kh\u00e1ch ti\u1ebfn h\u00e0nh tr\u1ea3 ph\u00f2ng t\u1edbi khi k\u1ebft th\u1eddi h\u1ea1n tr\u1ea3 ph\u00f2ng l\u00fac \u0111\u1ea7u \u0111\u00e3 \u0111\u1eb7t \u0111\u1ec3 xem c\u00f2n d\u01b0 kho\u1ea3ng m\u1ea5y ng\u00e0y.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00fa ph\u00e1p c\u1ee7a h\u00e0m chia MOD l\u00e0: =MOD(B3-A3,7). V\u1edbi h\u00e0m n\u00e0y, b\u1ea1n ph\u1ea3i l\u1ea5y s\u1ed1 ng\u00e0y m\u00e0 kh\u00e1ch tr\u1ea3 ph\u00f2ng tr\u1eeb \u0111i s\u1ed1 ng\u00e0y m\u00e0 kh\u00e1ch nh\u1eadn ph\u00f2ng. Ti\u1ebfp \u0111\u00f3 th\u00ec b\u1ea1n l\u1ea5y k\u1ebft qu\u1ea3 tr\u1eeb n\u00e0y chia cho s\u1ed1 7 \u0111\u1ec3 t\u00ednh xem s\u1ed1 d\u01b0 ra trong k\u1ebft qu\u1ea3 l\u00e0 bao nhi\u00eau v\u00e0 x\u00e9t hai tr\u01b0\u1eddng h\u1ee3p nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 (S\u1ed1 ng\u00e0y kh\u00e1ch tr\u1ea3 &#8211; S\u1ed1 ng\u00e0y kh\u00e1ch nh\u1eadn ph\u00f2ng) : 7 = 0 th\u00ec ph\u00e9p chia n\u00e0y chia h\u1ebft v\u00e0 h\u1ecd \u0111\u00e3 \u1edf kh\u00e1ch s\u1ea1n h\u1ebft th\u1eddi h\u1ea1n \u0111\u1eb7t ph\u00f2ng l\u00fac \u0111\u1ea7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 (S\u1ed1 ng\u00e0y kh\u00e1ch tr\u1ea3 &#8211; S\u1ed1 ng\u00e0y kh\u00e1ch nh\u1eadn ph\u00f2ng) : 7 = 2, 3, 4,&#8230; th\u00ec ph\u00e9p chia c\u00f3 s\u1ed1 d\u01b0 v\u00e0 kh\u00e1ch v\u1eabn ch\u01b0a \u1edf kh\u00e1ch s\u1ea1n h\u1ebft th\u1eddi h\u1ea1n \u0111\u00e3 \u0111\u1eb7t l\u00fac \u0111\u1ea7u.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312971 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-7.jpg\" alt=\"ham-mod-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady b\u1ea1n t\u00ednh \u0111\u01b0\u1ee3c s\u1ed1 ng\u00e0y m\u00e0 kh\u00e1ch \u1edf kh\u00e1ch s\u1ea1n qua ph\u00e9p t\u00ednh \u0111\u01a1n gi\u1ea3n l\u00e0 S\u1ed1 tu\u1ea7n * 7 &#8211; S\u1ed1 ng\u00e0y \u1edf c\u00f2n d\u01b0.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t v\u00e0i l\u1ed7i li\u00ean quan \u0111\u1ebfn qu\u00e1 tr\u00ecnh d\u00f9ng h\u00e0m MOD trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Khi s\u1eed d\u1ee5ng h\u00e0m chia MOD th\u00ec m\u1ecdi ng\u01b0\u1eddi th\u01b0\u1eddng g\u1eb7p m\u1ed9t v\u00e0i l\u1ed7i ph\u1ed5 bi\u1ebfn nh\u01b0 sau. M\u1ecdi ng\u01b0\u1eddi h\u00e3y theo d\u00f5i v\u00e0 kh\u1eafc ph\u1ee5c ngay.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i k\u1ebft qu\u1ea3 d\u1ea1ng #DIV\/0!<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">N\u1ebfu nh\u01b0 nh\u1eadp h\u00e0m chia MOD v\u00e0 b\u1ea1n g\u1eb7p l\u1ed7i n\u00e0y th\u00ec nguy\u00ean nh\u00e2n l\u00e0 do gi\u00e1 tr\u1ecb m\u1eabu s\u1ed1 c\u1ee7a h\u00e0m = 0.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u2192 Kh\u1eafc ph\u1ee5c: B\u1ea1n h\u00e3y thay gi\u00e1 tr\u1ecb c\u1ee7a m\u1eabu s\u1ed1 ho\u1eb7c thay \u0111\u1ed5i ph\u00e9p t\u00ednh v\u00ec c\u00f3 khi ph\u00e9p chia n\u00e0y kh\u00f4ng ch\u1ee9a s\u1ed1 n\u00e0o chia \u0111\u01b0\u1ee3c cho s\u1ed1 0.<\/span><\/p>\n<figure id=\"attachment_312978\" aria-describedby=\"caption-attachment-312978\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-312978 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-14.jpg\" alt=\"ham-mod-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-312978\" class=\"wp-caption-text\">L\u1ed7i k\u1ebft qu\u1ea3 d\u1ea1ng #DIV\/0! khi nh\u1eadp h\u00e0m MOD<\/figcaption><\/figure>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i k\u1ebft qu\u1ea3 d\u1ea1ng #VALUE<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i k\u1ebft qu\u1ea3 n\u00e0y s\u1ebd g\u1eb7p khi b\u1ea1n \u0111\u00e3 \u0111i\u1ec1n sai h\u00e0m MOD trong Excel. Nhi\u1ec1u khi l\u00fd do b\u1eaft ngu\u1ed3n t\u1eeb m\u1ed9t trong hai \u0111\u1ed1i s\u1ed1 m\u00e0 b\u1ea1n \u0111i\u1ec1n v\u00e0o kh\u00f4ng \u0111\u01b0\u1ee3c coi l\u00e0 s\u1ed1 m\u00e0 n\u00f3 ch\u1ec9 l\u00e0 ch\u1eef ho\u1eb7c k\u00fd t\u1ef1.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u2192 Kh\u1eafc ph\u1ee5c: B\u1ea1n h\u00e3y ki\u1ec3m tra k\u1ef9 nh\u1eefng \u0111\u1ed1i s\u1ed1 trong ph\u00e9p chia v\u00e0 \u0111i\u1ec1n l\u1ea1i.\u00a0<\/span><\/p>\n<figure id=\"attachment_312979\" aria-describedby=\"caption-attachment-312979\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-312979 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-15.jpg\" alt=\"ham-mod-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-312979\" class=\"wp-caption-text\">L\u1ed7i k\u1ebft qu\u1ea3 d\u1ea1ng #VALUE! khi nh\u1eadp h\u00e0m MOD<\/figcaption><\/figure>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i n\u00e0y r\u1ea5t hay di\u1ec5n ra, nguy\u00ean nh\u00e2n do \u00f4 d\u1eef li\u1ec7u b\u1ea1n \u0111ang \u0111i\u1ec1n c\u00f3 ch\u1ee9a \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u2192 Kh\u1eafc ph\u1ee5c: B\u1ea1n h\u00e3y \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 d\u1eef li\u1ec7u \u0111\u00f3 l\u00e0 ki\u1ec3u Number. B\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m chu\u1ed9t b\u00ean ph\u1ea3i \u1edf \u00f4 \u0111ang \u0111i\u1ec1n. Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn v\u00e0o Format Cell \u2192 B\u1ea5m v\u00e0o th\u1ebb Number \u2192 B\u1ea5m v\u00e0o Number \u2192 B\u1ea5m OK \u0111\u1ec3 kh\u1eafc ph\u1ee5c.<\/span><\/p>\n<figure id=\"attachment_312980\" aria-describedby=\"caption-attachment-312980\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-312980 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-16.jpg\" alt=\"ham-mod-trong-excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-312980\" class=\"wp-caption-text\">L\u1ed7i \u0111\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng\u00a0khi nh\u1eadp h\u00e0m MOD<\/figcaption><\/figure>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 h\u00e0m chia kh\u00e1c trong Excel<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh h\u00e0m MOD trong Excel th\u00ec hi\u1ec7n nay c\u00f3 m\u1ed9t s\u1ed1 h\u00e0m chia kh\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o \u0111\u1ec3 v\u1eadn d\u1ee5ng th\u00eam:<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m chia Excel c\u01a1 b\u1ea3n<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 l\u00e0m ph\u00e9p chia c\u01a1 b\u1ea3n trong b\u1ea3ng t\u00ednh Excel th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n d\u00f9ng c\u00f4ng th\u1ee9c to\u00e1n t\u1eed v\u1edbi d\u1ea5u g\u1ea1ch ch\u00e9o. Tr\u01b0\u1edbc khi vi\u1ebft c\u00f4ng th\u1ee9c n\u00e0y v\u00e0o \u00f4 xu\u1ea5t k\u1ebft qu\u1ea3 th\u00ec b\u1ea1n d\u00f9ng th\u00eam d\u1ea5u b\u1eb1ng \u1edf tr\u01b0\u1edbc. N\u1ebfu kh\u00f4ng nh\u1eadp d\u1ea5u n\u00e0y th\u00ec Excel hi\u1ec3u b\u1ea1n ch\u1ec9 mu\u1ed1n m\u00f4 t\u1ea3 n\u1ed9i dung l\u00e0 ng\u00e0y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m chia c\u01a1 b\u1ea3n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n trong Excel l\u00e0: = \u00f4 ch\u1ee9a d\u1eef li\u1ec7u l\u00e0 t\u1eed s\u1ed1 (s\u1ed1 b\u1ecb chia)\/ \u00f4 ch\u1ee9a d\u1eef li\u1ec7u l\u00e0 m\u1eabu s\u1ed1 (s\u1ed1 chia).\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: Ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau v\u00e0 b\u1ea1n h\u00e3y t\u00ednh to\u00e1n gi\u00e1 ti\u1ec1n tr\u00ean m\u1ed7i s\u1ea3n ph\u1ea9m:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: N\u1ebfu mu\u1ed1n t\u00ednh to\u00e1n gi\u00e1 c\u1ee7a b\u00ecnh n\u01b0\u1edbc th\u00ec b\u1ea1n r\u00ea chu\u1ed9t t\u1edbi \u00f4 F6.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312973 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-9.jpg\" alt=\"ham-mod-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Sau \u0111\u00f3 b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c chia b\u1eb1ng vi\u1ec7c b\u1ea5m d\u1ea5u b\u1eb1ng (=) r\u1ed3i b\u1ea5m v\u00e0o \u00f4 E6, ti\u1ebfp \u0111\u00f3 g\u00f5 d\u1ea5u chia (\/) v\u00e0 b\u1ea5m chu\u1ed9t \u1edf \u00f4 D6.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312974 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-10.jpg\" alt=\"ham-mod-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Khi \u0111\u00e3 \u0111i\u1ec1n xong th\u00ec b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m Enter. Khi \u0111\u00f3 th\u00ec \u00f4 F6 s\u1ebd xu\u1ea5t k\u1ebft qu\u1ea3 ch\u1ee9a gi\u00e1 ti\u1ec1n 1 b\u00ecnh n\u01b0\u1edbc.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312975 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-11.jpg\" alt=\"ham-mod-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: V\u1edbi c\u00e1c s\u1ea3n ph\u1ea9m kh\u00e1c trong b\u1ea3ng, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1eb7t chu\u1ed9t \u1edf g\u00f3c d\u01b0\u1edbi \u1edf b\u00ean ph\u1ea3i \u00f4 F6 r\u1ed3i k\u00e9o chu\u1ed9t v\u00e0 th\u1ea3 \u1edf \u00f4 F10. C\u00f4ng th\u1ee9c h\u00e0m chia s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng \u1edf c\u00e1c \u00f4 n\u00e0y v\u00e0 xu\u1ea5t ra k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.\u00a0<\/span><\/li>\n<\/ul>\n<h3><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn d\u00f9ng h\u00e0m QUOTIENT \u0111\u1ec3 chia l\u1ea5y s\u1ed1 nguy\u00ean<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y kh\u00e1c v\u1edbi h\u00e0m MOD trong Excel ch\u1ec9 th\u1ef1c hi\u1ec7n ph\u00e9p chia \u0111\u1ec3 l\u1ea5y ph\u1ea7n d\u01b0. V\u1edbi h\u00e0m QUOTIENT th\u00ec b\u1ea1n s\u1ebd th\u1ef1c hi\u1ec7n ph\u00e9p chia \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean trong k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c nh\u1eadp h\u00e0m chia QUOTIENT \u0111\u1ec3 l\u1ea5y s\u1ed1 nguy\u00ean l\u00e0: =QUOTIENT(numerator;denominator). Trong \u0111\u00f3 b\u1ea1n b\u1eaft bu\u1ed9c ph\u1ea3i nh\u1eadp:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Numerator: T\u1eed s\u1ed1 hay s\u1ed1 b\u1ecb chia.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Denominator: M\u1eabu s\u1ed1 hay s\u1ed1 chia.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 bi\u1ebft c\u00e1ch d\u00f9ng chi ti\u1ebft c\u1ee7a h\u00e0m QUOTIENT th\u00ec b\u1ea1n h\u00e3y xem v\u00ed d\u1ee5 minh h\u1ecda v\u1ec1 ph\u00e9p chia c\u1ee5 th\u1ec3 l\u00e0 8 chia 3. N\u1ebfu b\u1ea1n d\u00f9ng c\u00e1ch t\u00ednh nh\u1ea9m th\u00ec \u0111\u00e3 bi\u1ebft ph\u00e9p chia n\u00e0y ra 1 s\u1ed1 d\u1ea1ng th\u1eadp ph\u00e2n. Khi d\u00f9ng h\u00e0m QUOTIENT th\u00ec ph\u00e9p chia th\u1ef1c hi\u1ec7n nh\u01b0 sau:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: \u1ede \u00f4 xu\u1ea5t k\u1ebft qu\u1ea3 l\u00e0 D5, b\u1ea1n \u0111i\u1ec1n h\u00e0m l\u00e0: =QUOTIENT(B5;C5).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312976 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-12.jpg\" alt=\"ham-mod-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Khi \u0111\u00f3, b\u1ea1n h\u00e3y b\u1ea5m Enter \u0111\u1ec3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 \u00f4 D5 l\u00e0 2.\u00a0<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/01\/ham-mod-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-312977 aligncenter webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-13.jpg\" alt=\"ham-mod-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">Nh\u01b0 v\u1eady khi l\u1ea5y 8 chia 3 th\u00ec ch\u00fang ta \u0111\u01b0\u1ee3c ph\u1ea7n nguy\u00ean l\u00e0 2 v\u00e0 d\u01b0 2. Nh\u01b0ng v\u1edbi h\u00e0m QUOTIENT th\u00ec n\u00f3 ch\u1ec9 l\u1ea5y ph\u1ea7n nguy\u00ean l\u00e0 2 v\u00e0 b\u1ecf s\u1ed1 th\u1eadp ph\u1ea7n \u1edf sau d\u1ea5u ph\u1ea9y.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ch\u00fa \u00fd: N\u1ebfu nh\u01b0 1 trong 2 gi\u00e1 tr\u1ecb m\u1eabu s\u1ed1 v\u00e0 t\u1ef1 s\u1ed1 kh\u00f4ng ch\u1ee9a \u0111\u1ecbnh d\u1ea1ng l\u00e0 s\u1ed1 th\u00ec h\u00e0m l\u1ea5y ph\u1ea7n nguy\u00ean s\u1ebd xu\u1ea5t k\u1ebft qu\u1ea3 c\u00f3 l\u1ed7i l\u00e0 #VALUE.<\/span><\/p>\n<h2>L\u1eddi k\u1ebft<\/h2>\n<p><span style=\"font-weight: 400;\">To\u00e0n b\u1ed9 b\u00e0i vi\u1ebft tr\u00ean \u0111\u00e3 chia s\u1ebb v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel \u0111\u1ec3 l\u1ea5y ph\u1ea7n d\u01b0 trong ph\u00e9p chia. M\u1ecdi ng\u01b0\u1eddi c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng h\u00e0m n\u00e0y \u0111\u1ec3 x\u1eed l\u00fd s\u1ed1 li\u1ec7u trong c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c h\u01a1n. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng nh\u1eefng h\u00e0m chia t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 m\u00e0 m\u00ecnh mong mu\u1ed1n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tham kh\u1ea3o b\u00e0i vi\u1ebft li\u00ean quan:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/wrap-text\/\">C\u00e1ch d\u00f9ng Wrap Text trong Microsoft Excel<\/a><\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-match\/\">H\u00e0m Match trong Excel: C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Match k\u00e8m v\u00ed d\u1ee5<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m MOD trong Excel l\u00e0 m\u1ed9t h\u00e0m chia c\u01a1 b\u1ea3n \u0111\u1ec3 ng\u01b0\u1eddi t\u00ednh to\u00e1n l\u1ea5y \u0111\u01b0\u1ee3c ph\u1ea7n d\u01b0 m\u00ecnh c\u1ea7n trong k\u1ebft qu\u1ea3. N\u1ebfu b\u1ea1n ph\u1ea3i x\u1eed l\u00fd s\u1ed1 li\u1ec7u tr\u00ean b\u1ea3ng t\u00ednh h\u00e0ng ng\u00e0y th\u00ec h\u00e0m MOD n\u00e0y r\u1ea5t quan tr\u1ecdng. N\u00f3 s\u1ebd gi\u00fap b\u1ea1n ph\u00e2n t\u00edch c\u00e1c s\u1ed1 li\u1ec7u nhanh ch\u00f3ng v\u00e0 n\u00e2ng [&hellip;]<\/p>\n","protected":false},"author":102,"featured_media":312964,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16,412],"tags":[],"class_list":["post-312962","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat","category-thu-thuat-may-tinh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0<\/title>\n<meta name=\"description\" content=\"C\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel s\u1ebd gi\u00fap m\u1ecdi ng\u01b0\u1eddi x\u1eed l\u00fd c\u00e1c b\u1ea3ng s\u1ed1 li\u1ec7u nhanh ch\u00f3ng h\u01a1n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel s\u1ebd gi\u00fap m\u1ecdi ng\u01b0\u1eddi x\u1eed l\u00fd c\u00e1c b\u1ea3ng s\u1ed1 li\u1ec7u nhanh ch\u00f3ng h\u01a1n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-31T08:05:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"15 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/\"},\"author\":{\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0\",\"datePublished\":\"2024-01-31T08:05:23+00:00\",\"dateModified\":\"2024-01-31T08:05:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/\"},\"wordCount\":2999,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\",\"Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg\",\"datePublished\":\"2024-01-31T08:05:23+00:00\",\"dateModified\":\"2024-01-31T08:05:23+00:00\",\"description\":\"C\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel s\u1ebd gi\u00fap m\u1ecdi ng\u01b0\u1eddi x\u1eed l\u00fd c\u00e1c b\u1ea3ng s\u1ed1 li\u1ec7u nhanh ch\u00f3ng h\u01a1n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-mod-trong-excel-17\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4\",\"name\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g\",\"caption\":\"Nguy\u1ec5n Xu\u00e2n Thi\u00ean\"},\"description\":\"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0","description":"C\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel s\u1ebd gi\u00fap m\u1ecdi ng\u01b0\u1eddi x\u1eed l\u00fd c\u00e1c b\u1ea3ng s\u1ed1 li\u1ec7u nhanh ch\u00f3ng h\u01a1n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.","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:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0","og_description":"C\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel s\u1ebd gi\u00fap m\u1ecdi ng\u01b0\u1eddi x\u1eed l\u00fd c\u00e1c b\u1ea3ng s\u1ed1 li\u1ec7u nhanh ch\u00f3ng h\u01a1n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2024-01-31T08:05:23+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg","type":"image\/jpeg"}],"author":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"15 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/"},"author":{"name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0","datePublished":"2024-01-31T08:05:23+00:00","dateModified":"2024-01-31T08:05:23+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/"},"wordCount":2999,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt","Th\u1ee7 thu\u1eadt m\u00e1y t\u00ednh"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg","datePublished":"2024-01-31T08:05:23+00:00","dateModified":"2024-01-31T08:05:23+00:00","description":"C\u00e1ch d\u00f9ng h\u00e0m MOD trong Excel s\u1ebd gi\u00fap m\u1ecdi ng\u01b0\u1eddi x\u1eed l\u00fd c\u00e1c b\u1ea3ng s\u1ed1 li\u1ec7u nhanh ch\u00f3ng h\u01a1n v\u00e0 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c.","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/01\/ham-mod-trong-excel-17.jpg","width":1200,"height":628,"caption":"ham-mod-trong-excel-17"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-mod-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MOD trong Excel \u0111\u1ec3 chia l\u1ea5y ph\u1ea7n d\u01b0"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/26499da0a8947cbc1d286a6c25f0d1a4","name":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e5cc5b9fee69402140e5b8ea8828660?s=96&d=mm&r=g","caption":"Nguy\u1ec5n Xu\u00e2n Thi\u00ean"},"description":"Ch\u00e0o c\u00e1c b\u1ea1n, m\u00ecnh l\u00e0 Xu\u00e2n Thi\u00ean. Trong k\u1ef7 nguy\u00ean s\u1ed1 thay \u0111\u1ed5i t\u1eebng gi\u1edd, m\u00ecnh \u1edf \u0111\u00e2y \u0111\u1ec3 c\u00f9ng b\u1ea1n c\u1eadp nh\u1eadt v\u00e0 ph\u00e2n t\u00edch nh\u1eefng chuy\u1ec3n \u0111\u1ed9ng m\u1edbi nh\u1ea5t c\u1ee7a th\u1ebf gi\u1edbi c\u00f4ng ngh\u1ec7. B\u1eb1ng s\u1ef1 am hi\u1ec3u v\u1ec1 h\u1ec7 sinh th\u00e1i c\u00e1c s\u1ea3n ph\u1ea9m c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, m\u00ecnh cam k\u1ebft mang \u0111\u1ebfn cho b\u1ea1n nh\u1eefng g\u00f3c nh\u00ecn tr\u1ef1c quan, h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0m ch\u1ee7 c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch th\u00f4ng minh nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/nguyen-xuan-thien\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/312962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=312962"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/312962\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/312964"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=312962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=312962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=312962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}