{"id":259992,"date":"2023-10-11T20:40:17","date_gmt":"2023-10-11T13:40:17","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=259992"},"modified":"2023-10-11T20:40:17","modified_gmt":"2023-10-11T13:40:17","slug":"lam-tron-so-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/","title":{"rendered":"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng th\u1eafc m\u1eafc c\u00f3 ph\u01b0\u01a1ng ph\u00e1p n\u00e0o l\u00e0m tr\u00f2n s\u1ed1 nhanh h\u1ed7 tr\u1ee3 t\u1ed1t c\u00f4ng vi\u1ec7c l\u00e0m b\u00e1o c\u00e1o, nh\u1eadp li\u1ec7u hay tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u hay kh\u00f4ng? H\u00f4m nay Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n nh\u1eefng c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong excel.\u00a0\u00a0<\/span><\/p>\n<h2><strong>L\u1ee3i \u00edch vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 trong excel<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 trong excel mang \u0111\u1ebfn 5 \u01b0u \u0111i\u1ec3m n\u1ed5i b\u1eadt v\u1edbi nh\u1eefng ng\u01b0\u1eddi d\u00f9ng v\u0103n ph\u00f2ng. C\u1ee5 th\u1ec3:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u nhanh ch\u00f3ng gi\u00fap ng\u01b0\u1eddi d\u00f9ng l\u00e0m b\u00e1o c\u00e1o s\u1ed1 c\u00f3 \u0111\u1ed9 ch\u00ednh x\u00e1c cao h\u01a1n<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Ti\u1ebft ki\u1ec7m th\u1eddi gian h\u01a1n r\u1ea5t nhi\u1ec1u khi ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi t\u1ec7p d\u1eef li\u1ec7u l\u1edbn.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">T\u1ec9 l\u1ec7 l\u1ed7i hay sai s\u00f3t \u0111\u01b0\u1ee3c h\u1ea1n ch\u1ebf so v\u1edbi vi\u1ec7c nh\u1eadp li\u1ec7u th\u1ee7 c\u00f4ng<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260141\" aria-describedby=\"caption-attachment-260141\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-260141 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-11.jpg\" alt=\"lam-tron so-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260141\" class=\"wp-caption-text\">3 \u01b0u \u0111i\u1ec3m c\u1ee7a vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 trong excel<\/figcaption><\/figure>\n<h2>5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng H\u00e0m Round<\/h2>\n<p><span style=\"font-weight: 400;\">H\u00e0m ROUND l\u00e0 h\u00e0m gi\u00fap l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 d\u1ef1a tr\u00ean \u0111\u1ed1i s\u1ed1 m\u00e0 ng\u01b0\u1eddi d\u00f9ng mong mu\u1ed1n. B\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u00e0m tr\u00f2n s\u1ed1 nh\u01b0 mong mu\u1ed1n v\u00e0 th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh mang t\u00ednh chi\u1ebfn l\u01b0\u1ee3c. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROUND, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo nh\u1eefng b\u01b0\u1edbc sau \u0111\u00e2y.\u00a0<\/span><\/p>\n<h3><strong>L\u00e0m tr\u00f2n s\u1ed1 h\u00e0m Round v\u1edbi \u0111\u1ed1i s\u1ed1 d\u01b0\u01a1ng<\/strong><\/h3>\n<p>V\u1edbi \u0111\u1ed1i s\u1ed1 d\u01b0\u01a1ng, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u1ecdc l\u1ea5y s\u1ed1 li\u1ec7u ph\u1ea7n th\u1eadp ph\u00e2n c\u1ee7a m\u1ed9t s\u1ed1 cho c\u00f4ng vi\u1ec7c v\u00e0 l\u00e0m b\u00e1o c\u00e1o d\u1eef li\u1ec7u.<\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><strong>= ROUND(Number;n)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\"> Number: S\u1ed1 mu\u1ed1n l\u00e0m tr\u00f2n<\/span><\/li>\n<li><span style=\"font-weight: 400;\">n: s\u1ed1 ph\u1ea7n nguy\u00ean mu\u1ed1n l\u00e0m tr\u00f2n<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5: C\u00f4ng th\u1ee9c sau \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=ROUND(2,17;1), l\u00e0m tr\u00f2n 2,17 \u0111\u1ebfn 1 v\u1ecb tr\u00ed th\u1eadp ph\u00e2n, k\u1ebft qu\u1ea3 s\u1ebd cho ra 2,2<\/span><\/p>\n<p><span style=\"font-weight: 400;\">=ROUND(2,159;1), l\u00e0m tr\u00f2n 2,159 \u0111\u1ebfn 1 v\u1ecb tr\u00ed th\u1eadp ph\u00e2n, k\u1ebft qu\u1ea3 s\u1ebd cho ra 2,2<\/span><\/p>\n<figure id=\"attachment_260139\" aria-describedby=\"caption-attachment-260139\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-260139 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-1.jpg\" alt=\"lam-tron so-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260139\" class=\"wp-caption-text\">L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng h\u00e0m ROUND<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\"><strong>L\u01b0u \u00fd:<\/strong> V\u1edbi ph\u1ea7n th\u1eadp ph\u00e2n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0.5 th\u00ec h\u00e0m Number s\u1ebd l\u00e0m tr\u00f2n l\u00ean, c\u00f2n nh\u1ecf h\u01a1n 0.5 s\u1ebd l\u00e0m tr\u00f2n xu\u1ed1ng.<\/span><\/p>\n<h3><strong>L\u00e0m tr\u00f2n s\u1ed1 v\u1edbi h\u00e0m Round v\u1edbi \u0111\u1ed1i s\u1ed1 \u00e2m<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">C\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 vi\u1ec7c th\u1ef1c hi\u1ec7n v\u1edbi h\u00e0m ROUND \u0111\u1ed1i s\u1ed1 d\u01b0\u01a1ng, ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 vi\u1ec7c s\u1ed1 ph\u1ea7n nguy\u00ean mong mu\u1ed1n l\u00e0m tr\u00f2n th\u00e0nh ch\u1eef s\u1ed1 \u00e2m \u0111\u1ec3 l\u00e0m tr\u00f2n c\u1ea3 ph\u1ea7n nguy\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><strong>= ROUND( Number, n)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number: S\u1ed1 mu\u1ed1n l\u00e0m tr\u00f2n<\/span><\/li>\n<li><span style=\"font-weight: 400;\">n: s\u1ed1 ph\u1ea7n nguy\u00ean mu\u1ed1n l\u00e0m tr\u00f2n (n &lt; 0)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 21,8 th\u00ec h\u00e0m Round (21.8,-1)\u00a0 c\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 20.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 25,8 th\u00ec h\u00e0m Round (25.8,-1)\u00a0 c\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 30.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260138\" aria-describedby=\"caption-attachment-260138\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-260138 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-2.jpg\" alt=\"lam-tron so-trong-excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260138\" class=\"wp-caption-text\">V\u00ed d\u1ee5 v\u1edbi h\u00e0m ROUND \u0111\u1ed1i s\u1ed1 \u00e2m<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: Quy t\u1eafc l\u00e0m tr\u00f2n c\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean, c\u00e1c s\u1ed1 l\u1edbn ph\u1ea7n nguy\u00ean l\u1edbn h\u01a1n 5 s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n l\u00ean c\u00f2n v\u1edbi ch\u1eef s\u1ed1 ph\u1ea7n nguy\u00ean nh\u1ecf h\u01a1n 5 th\u00ec \u0111\u1ec1u \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n xu\u1ed1ng. C\u00e1c b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u1eb7c bi\u1ec7t c\u1ea9n th\u1eadn \u0111\u1ec3 kh\u00f4ng d\u1eabn \u0111\u1ebfn nh\u1eefng l\u1ed7i sai kh\u00f4ng mong mu\u1ed1n.<\/span><\/p>\n<h3><strong>C\u00e1ch l\u00e0m tr\u00f2n l\u00ean trong Excel b\u1eb1ng h\u00e0m ROUNDUP<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">ROUNDUP l\u00e0 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong excel v\u1edbi k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 lu\u00f4n l\u00e0 s\u1ed1 l\u1edbn h\u01a1n v\u1edbi s\u1ed1 ban \u0111\u1ea7u \u0111\u1ea7u (hay c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0m tr\u00f2n l\u00ean). C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m s\u1ed1 n\u00e0y v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n theo c\u00f4ng th\u1ee9c ngay sau \u0111\u00e2y.<\/span><\/p>\n<p><strong>=ROUNDUP(Number, ph\u1ea7n nguy\u00ean c\u1ea7n l\u00e0m tr\u00f2n)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 21,123 th\u00ec h\u00e0m ROUNDUP(21,123;1)\u00a0 c\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 21,2<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 21,453 th\u00ec h\u00e0m ROUNDUP(21,123;1)\u00a0 c\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 21,5<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260137\" aria-describedby=\"caption-attachment-260137\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-260137 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-3.jpg\" alt=\"lam-tron so-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260137\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ROUNDUP<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd: Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u1ecdn gi\u00e1 tr\u1ecb \u00e2m \u0111\u1ec3 l\u00e0m tr\u00f2n v\u1edbi ph\u1ea7n th\u1eadp ph\u00e2n v\u00e0 ng\u01b0\u1ee3c l\u1ea1i \u0111\u1ec3 l\u00e0m tr\u00f2n c\u00e1c gi\u00e1 tr\u1ecb ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1. C\u00e1c quy t\u1eafc l\u00e0m tr\u00f2n c\u0169ng gi\u1ed1ng h\u1ebft nh\u01b0 v\u1edbi h\u00e0m ROUND th\u00f4ng th\u01b0\u1eddng.<\/span><\/p>\n<h3><strong>C\u00e1ch l\u00e0m tr\u00f2n xu\u1ed1ng trong Excel b\u1eb1ng h\u00e0m ROUNDDOWN<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">ROUNDDOWN l\u00e0 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 xu\u1ed1ng hay l\u00e0m tr\u00f2n \u0111\u1ebfn gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n v\u1edbi gi\u00e1 tr\u1ecb ban \u0111\u1ea7u. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c ngay sau \u0111\u00e2y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><strong>= ROUNDDOWN(Number, ph\u1ea7n nguy\u00ean c\u1ea7n l\u00e0m tr\u00f2n)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 21,123 th\u00ec h\u00e0m ROUNDDOWN(21,123;2) c\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 21,12<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 8,133 th\u00ec h\u00e0m ROUNDDOWN(8,133;2) c\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 8,13<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 125,18 th\u00ec h\u00e0m ROUNDDOWN(125,18;1) c\u00f3 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 125,1<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260136\" aria-describedby=\"caption-attachment-260136\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-260136 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-4.jpg\" alt=\"lam-tron so-trong-excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260136\" class=\"wp-caption-text\">H\u00e0m ROUNDDOWN l\u00e0m tr\u00f2n s\u1ed1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, c\u00e1c l\u01b0u \u00fd trong vi\u1ec7c s\u1eed d\u1ee5ng c\u1ee7a h\u00e0m ROUNDDOWNc\u0169ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1edbi h\u00e0m ROUNDUP ph\u00eda tr\u00ean.<\/span><\/p>\n<h3><strong>C\u00e1ch l\u00e0m trong s\u1ed1 v\u1edbi h\u00e0m MROUND<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m MROUND t\u01b0\u01a1ng \u0111\u1ed1i ph\u1ee9c t\u1ea1p. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m l\u00e0m tr\u00f2n d\u1ef1a tr\u00ean b\u1ed9i s\u1ed1. \u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 h\u00e0m n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00f4ng th\u1ee9c v\u00e0 nh\u1eefng v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c:<\/span><\/p>\n<p><strong>=MROUND(number, n).<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">number: Gi\u00e1 tr\u1ecb mu\u1ed1n l\u00e0m tr\u00f2n, l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">n: B\u1ed9i s\u1ed1 mu\u1ed1n l\u00e0m tr\u00f2n t\u1edbi, l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260135\" aria-describedby=\"caption-attachment-260135\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-260135 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-5.jpg\" alt=\"lam-tron so-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260135\" class=\"wp-caption-text\">H\u00e0m MROUND l\u00e0m tr\u00f2n s\u1ed1<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 \u00e1p d\u1ee5ng c\u00e1c b\u1ea1n c\u1ea7n ph\u1ea3i l\u01b0u \u00fd m\u1ed9t s\u1ed1 \u0111i\u1ec1u nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">H\u00e0m MROUND s\u1ebd l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb l\u00ean khi v\u00e0 ch\u1ec9 khi gi\u00e1 tr\u1ecb c\u1ee7a ph\u00e9p chia number cho n l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng m\u1ed9t n\u1eeda gi\u00e1 tr\u1ecb c\u1ee7a n<\/span><\/li>\n<li>Tr\u01b0\u1eddng h\u1ee3p gi\u00e1 tr\u1ecb Number v\u00e0 n kh\u00e1c d\u1ea5u -&gt; h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1ed7i #NUM!<\/li>\n<li>Khi k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 #Num khi gi\u00e1 tr\u1ecb hi\u1ec3n th\u1ecb kh\u00e1c d\u1ea5u so v\u1edbi gi\u00e1 tr\u1ecb number. K\u1ebft qu\u1ea3 ch\u1ec9 ch\u00ednh x\u00e1c khi d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1 c\u00f9ng d\u1ea5u. C\u00e1ch kh\u1eafc ph\u1ee5c, ng\u01b0\u1eddi d\u00f9ng n\u00ean \u0111\u1ec3 gi\u00e1 tr\u1ecb number v\u00e0 b\u1ed9i s\u1ed1 n c\u00f9ng d\u1ea5u v\u1edbi nhau.<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= MROUND(5,3) k\u1ebft qu\u1ea3 cho ra s\u1ebd l\u00e0 6<\/span><\/p>\n<p><span style=\"font-weight: 400;\">= MROUND(12,6) k\u1ebft qu\u1ea3 cho ra s\u1ebd l\u00e0 12<\/span><\/p>\n<p><span style=\"font-weight: 400;\"> Tr\u00ean \u0111\u00e2y l\u00e0 c\u00e1ch l\u00e0m tr\u00f2n trong excel v\u1edbi c\u00e1c h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng m\u1ed9t c\u00e1ch h\u1ee3p l\u00fd \u0111\u1ec3 c\u00f3 th\u1ec3 gi\u00fap t\u1ed1i \u01b0u trong c\u00f4ng vi\u1ec7c, t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u ch\u1ee9a ph\u1ea7n th\u1eadp ph\u00e2n. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u0169ng n\u00ean ch\u00fa \u00fd c\u00e1c l\u01b0u \u00fd \u1edf m\u1ed7i h\u00e0m \u0111\u1ec3 c\u00f3 th\u1ec3 v\u1eadn d\u1ee5ng ch\u00fang m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c nh\u1ea5t nh\u00e9.\u00a0<\/span><\/p>\n<h2>M\u1ed9t s\u1ed1 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 tr\u00ean Excel kh\u00e1c<\/h2>\n<p><span style=\"font-weight: 400;\">C\u00f3 r\u1ea5t nhi\u1ec1u c\u00e1ch c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n s\u1ed1 trong excel. Sau \u0111\u00e2y l\u00e0 nh\u1eefng h\u00e0m m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd c\u00e1c s\u1ed1 li\u1ec7u:<\/span><\/p>\n<h3><strong>L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng c\u00e1ch th\u00eam \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">Ph\u01b0\u01a1ng ph\u00e1p \u0111\u01a1n gi\u1ea3n, ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 \u0111\u01b0\u1ee3c c\u00e0i s\u1eb5n trong excel \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 li\u1ec7u. K\u1ebft qu\u1ea3 hi\u1ec3n th\u1ecb lu\u00f4n l\u00e0 ph\u1ea7n nguy\u00ean tuy nhi\u00ean nh\u01b0\u1ee3c \u0111i\u1ec3m \u0111\u00f3 l\u00e0 ph\u1ea7n nguy\u00ean s\u1ebd v\u1eabn \u0111\u01b0\u1ee3c t\u00ednh trong c\u00e1c ph\u00e9p to\u00e1n. Sau \u0111\u00e2y l\u00e0 4 b\u01b0\u1edbc gi\u00fap b\u1ea1n l\u00e0m tr\u00f2n s\u1ed1 nhanh ch\u00f3ng:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn \u00f4 ho\u1eb7c c\u1ed9t\u00a0 b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng, sau \u0111\u00f3 ch\u1ecdn m\u1ee5c General tr\u00ean thanh c\u00f4ng c\u1ee5.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u1ea5m t\u00f9y ch\u1ecdn Number Formats.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ch\u1ecdn m\u1ed9t trong nh\u1eefng \u0111\u1ecbnh d\u1ea1ng sau Ti\u1ec1n t\u1ec7 (Currency), K\u1ebf to\u00e1n (Accounting), T\u1ec9 l\u1ec7 ph\u1ea7n tr\u0103m (Percentage),&#8230;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 4: Ch\u1ecdn s\u1ed1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n m\u00e0 b\u1ea1n mong mu\u1ed1n \u0111\u1ec3 l\u1ea5y ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1.<\/span><\/p>\n<figure id=\"attachment_262458\" aria-describedby=\"caption-attachment-262458\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-21.png.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-21-300x169.png.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-21-768x432.png.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-262458 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-21.png\" alt=\"cach-lam-tron-so-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-21.png 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-21-300x169.png 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-21-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-262458\" class=\"wp-caption-text\">L\u00e0m tr\u00f2n s\u1ed1 b\u1eb1ng ch\u1ee9c n\u0103ng trong Excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, tr\u00ean thanh c\u00f4ng c\u1ee5 c\u0169ng c\u00f3 s\u1eb5n 2 ch\u1ee9c n\u0103ng t\u00f9y ch\u1ecdn t\u0103ng v\u00e0 gi\u1ea3m ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u00f9y ch\u1ec9nh theo mong mu\u1ed1n.<\/span><\/p>\n<h3>H\u00e0m INT c\u00f3 ch\u1ee9c n\u0103ng l\u00e0m tr\u00f2n m\u1ed9t s\u1ed1 b\u1ea5t k\u1ef3 th\u00e0nh s\u1ed1 nguy\u00ean<\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m INT l\u00e0 m\u1ed9t h\u00e0m d\u00f9ng \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb ph\u1ea7n nguy\u00ean c\u1ee7a s\u1ed1 v\u1edbi b\u1ea5t k\u00ec ph\u1ea7n th\u1eadp ph\u00e2n nh\u01b0 th\u1ebf n\u00e0o. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ngay d\u01b0\u1edbi \u0111\u00e2y.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>=INT(Number)<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3: Number l\u00e0 s\u1ed1, \u00f4 ho\u1eb7c ph\u00e9p chia<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 s\u1ed1 6,5, h\u00e0m =INT(6.5) tr\u1ea3 v\u1ec1 6<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 \u00f4 trong excel v\u00e0 \u00f4 \u0111\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb l\u00e0 10,6 th\u00ec =INT(\u00f4) tr\u1ea3 v\u1ec1 10<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 ph\u00e9p chia 10\/4 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 2<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260133\" aria-describedby=\"caption-attachment-260133\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-260133 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-7.jpg\" alt=\"lam-tron so-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260133\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u00e0m trong s\u1ed1 INT<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m INT \u0111\u1ec3 t\u00ednh s\u1ed1 ng\u00e0y \u1edf trong l\u0129nh v\u1ef1c kh\u00e1ch s\u1ea1n. V\u00ed d\u1ee5, B\u1ea1n c\u00f3 ng\u00e0y Check in v\u00e0 Check out.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3: =INT(S\u1ed1 ng\u00e0y Check in \u2013 S\u1ed1 ng\u00e0y Check Out).<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">S\u1ed1 ng\u00e0y check in l\u00e0 28\/04\/2023, s\u1ed1 ng\u00e0y check out l\u00e0 15\/05\/2023, h\u00e0m INT tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 17 ng\u00e0y.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">S\u1ed1 ng\u00e0y check in l\u00e0 18\/02\/2023, s\u1ed1 ng\u00e0y check out l\u00e0 15\/04\/2023, h\u00e0m INT tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 56 ng\u00e0y.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">S\u1ed1 ng\u00e0y check in l\u00e0 11\/01\/2023, s\u1ed1 ng\u00e0y check out l\u00e0 15\/04\/2023, h\u00e0m INT tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 94 ng\u00e0y.<\/span><\/li>\n<\/ul>\n<h3><strong>H\u00e0m TRUNC<\/strong><\/h3>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m ROUND, h\u00e0m TRUNC l\u00e0 h\u00e0m l\u00e0m tr\u00f2n s\u1ed1 trong excel s\u1eed d\u1ee5ng \u0111\u1ec3 c\u1eaft b\u1ecf ph\u1ea7n th\u1eadp ph\u00e2n sau d\u1ea5u ph\u1ea9y v\u00e0 gi\u1eef l\u1ea1i ph\u1ea7n nguy\u00ean theo mong mu\u1ed1n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng th\u00f4ng qua \u0111\u1ed1i s\u1ed1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c h\u00e0m l\u00e0m tr\u00f2n trong excel l\u00e0:<\/span><\/p>\n<p><strong>=TRUNC(Number, n)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">n l\u00e0 \u0111\u1ed1i s\u1ed1 ch\u1ec9 s\u1ed1 v\u1ecb tr\u00ed ph\u1ea7n nguy\u00ean c\u1ea7n l\u00e0m tr\u00f2n. Gi\u00e1 s\u1eed b\u1ea1n ch\u1ecdn 1 th\u00ec v\u1ecb tr\u00ed ph\u1ea7n nguy\u00ean c\u1ea7n l\u00e0m tr\u00f2n ngay sau d\u1ea5u ph\u1ea9y.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 32,1 h\u00e0m = TRUNC(32,12;1) th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 32,1<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 25,78, h\u00e0m = TRUNC(25,78;-1) th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 20<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 26,89 h\u00e0m = TRUNC(26,89;-2) th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 26<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260132\" aria-describedby=\"caption-attachment-260132\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-260132 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-8.jpg\" alt=\"lam-tron so-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260132\" class=\"wp-caption-text\">L\u00e0m tr\u00f2n s\u1ed1 v\u1edbi h\u00e0m TRUNC<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li>n l\u00e0 \u0111\u1ed1i s\u1ed1 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ph\u1ea7n th\u1eadp ph\u00e2n, ph\u00e2n nguy\u00ean m\u00e0 b\u1ea1n mong mu\u1ed1n l\u00e0m tr\u00f2n. Ngo\u00e0i ra, vi\u1ec7c l\u00e0m tr\u00f2n lu\u00f4n \u0111\u01b0\u1ee3c \u0111\u01b0a v\u1ec1 con s\u1ed1 0.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5:<\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 46,67, h\u00e0m = TRUNC(46,67;1) th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 46,7<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 46,67, h\u00e0m = TRUNC(46,67;-1) th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 40<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 46,67, h\u00e0m = TRUNC(46,67;0) th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 46<\/span><\/li>\n<\/ul>\n<h3><b>L\u00e0m tr\u00f2n s\u1ed1 trong excel v\u1edbi h\u00e0m ODD v\u00e0 EVEN<\/b><\/h3>\n<p><strong>H\u00e0m ODD<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m ODD d\u00f9ng \u0111\u1ec3 la\u0300m tro\u0300n l\u00ean t\u01a1\u0301i s\u00f4\u0301 nguy\u00ean le\u0309 g\u00e2\u0300n nh\u00e2\u0301t v\u00e0 xa s\u1ed1 0 h\u01a1n \u1edf c\u1ea3 \u00e2m v\u00e0 d\u01b0\u01a1ng tr\u00ean tr\u1ee5c s\u1ed1<\/span><\/p>\n<p><strong>C\u00f4ng th\u1ee9c t\u00ednh: =ODD(number)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 s\u1ed1 mong mu\u1ed1n l\u00e0m tr\u00f2n.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">N\u1ebfu number kh\u00f4ng ph\u1ea3i s\u1ed1, ha\u0300m ODD tr\u1ea3 v\u1ec1 gia\u0301 tri\u0323 l\u00f4\u0303i #VALUE! .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb c\u1ee7a s\u1ed1 h\u00e0m ODD \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n lu\u00f4n lu\u00f4n c\u00e1ch xa s\u1ed1 0 \u1edf c\u1ea3 hai b\u00ean c\u1ee7a tr\u1ee5c s\u1ed1.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">N\u00ea\u0301u number la\u0300 s\u00f4\u0301 nguy\u00ean l\u1ebb, thi\u0300 h\u00e0m s\u1ebd gi\u1eef nguy\u00ean v\u00e0 kh\u00f4ng l\u00e0m tr\u00f2n.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 44,1 th\u00ec h\u00e0m =ODD(44,1) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 45<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 -44,1 th\u00ec h\u00e0m =ODD(-44,1) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 -45<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 -47 th\u00ec h\u00e0m =ODD(-47) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 -47<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260131\" aria-describedby=\"caption-attachment-260131\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-260131 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-9.jpg\" alt=\"lam-tron so-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260131\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m ODD<\/figcaption><\/figure>\n<p><b>H\u00e0m EVEN<\/b><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m EVEN l\u00e0 h\u00e0m l\u00e0m tr\u00f2n trong excel t\u1edbi s\u00f4\u0301 nguy\u00ean ch\u1eb5n g\u00e2\u0300n nh\u00e2\u0301t, ra xa s\u1ed1 0. \u0110\u00e2y l\u00e0 h\u00e0m ng\u01b0\u1ee3c l\u1ea1i so v\u1edbi h\u00e0m ODD.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee5 th\u1ec3: <strong>=EVEN(number)<\/strong><\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3: Number l\u00e0 s\u1ed1 m\u00e0 b\u1ea1n mong mu\u1ed1n l\u00e0m tr\u00f2n<\/span><\/p>\n<p><span style=\"font-weight: 400;\">L\u01b0u \u00fd:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">N\u1ebfu number kh\u00f4ng ph\u1ea3i s\u1ed1, ha\u0300m EVEN tr\u1ea3 v\u1ec1 gia\u0301 tri\u0323 l\u00f4\u0303i #VALUE! .<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Gi\u00e1 tr\u1ecb c\u1ee7a s\u1ed1 h\u00e0m ODD \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n lu\u00f4n lu\u00f4n c\u00e1ch xa s\u1ed1 0 \u1edf c\u1ea3 hai b\u00ean tr\u1ee5c s\u1ed1.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">N\u00ea\u0301u number la\u0300 s\u00f4\u0301 nguy\u00ean l\u1ebb, thi\u0300 h\u00e0m s\u1ebd gi\u1eef nguy\u00ean v\u00e0 kh\u00f4ng l\u00e0m tr\u00f2n.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 43,1 th\u00ec h\u00e0m =ODD(43,1) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 44<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 -43,1 th\u00ec h\u00e0m =ODD(-43,1) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 -44<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Number l\u00e0 -44 th\u00ec h\u00e0m =ODD(-44) s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 -44<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_260140\" aria-describedby=\"caption-attachment-260140\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/09\/lam-tron-so-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-260140 size-full webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-10.jpg\" alt=\"lam-tron so-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-260140\" class=\"wp-caption-text\">C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 v\u1edbi h\u00e0m EVEN<\/figcaption><\/figure>\n<h2><strong>T\u1ea1m k\u1ebft<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">B\u00e0i vi\u1ebft tr\u00ean l\u00e0 5 c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong excel v\u1edbi h\u00e0m Round v\u00e0 m\u1ed9t s\u1ed1 h\u00e0m t\u01b0\u01a1ng t\u1ef1. Hy v\u1ecdng th\u00f4ng tin tr\u00ean s\u1ebd gi\u00fap b\u1ea1n trong c\u00f4ng vi\u1ec7c v\u00e0 h\u1ecdc t\u1eadp. Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 follow Fanpage Ho\u00e0ng H\u00e0 \u0111\u1ec3 lu\u00f4n nh\u1eadn \u0111\u01b0\u1ee3c th\u00f4ng b\u00e1o khi c\u00f3 tin t\u1ee9c m\u1edbi.\u00a0<\/span><\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/them-hang-trong-excel\/\">H\u01b0\u1edbng d\u1eabn c\u00e1c thao t\u00e1c \u0111\u01a1n gi\u1ea3n khi xo\u00e1, th\u00eam h\u00e0ng trong Excel<\/a><\/strong><\/li>\n<li class=\"elementor-heading-title elementor-size-default\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/pivot-table\/\">Pivot Table l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng Pivot Table trong Excel<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng th\u1eafc m\u1eafc c\u00f3 ph\u01b0\u01a1ng ph\u00e1p n\u00e0o l\u00e0m tr\u00f2n s\u1ed1 nhanh h\u1ed7 tr\u1ee3 t\u1ed1t c\u00f4ng vi\u1ec7c l\u00e0m b\u00e1o c\u00e1o, nh\u1eadp li\u1ec7u hay tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u hay kh\u00f4ng? H\u00f4m nay Ho\u00e0ng H\u00e0 Mobile s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn b\u1ea1n nh\u1eefng c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong excel.\u00a0\u00a0 L\u1ee3i \u00edch vi\u1ec7c l\u00e0m tr\u00f2n s\u1ed1 trong excel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":271341,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-259992","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"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>5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND<\/title>\n<meta name=\"description\" content=\"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....\" \/>\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\/lam-tron-so-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong excel v\u1edbi H\u00e0m ROUND\" \/>\n<meta property=\"og:description\" content=\"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-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:published_time\" content=\"2023-10-11T13:40:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.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=\"sialthuong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong excel v\u1edbi H\u00e0m ROUND\" \/>\n<meta name=\"twitter:description\" content=\"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"sialthuong\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 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\/lam-tron-so-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/\"},\"author\":{\"name\":\"sialthuong\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/ba9e95280c202ca5f157d73b65677d10\"},\"headline\":\"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND\",\"datePublished\":\"2023-10-11T13:40:17+00:00\",\"dateModified\":\"2023-10-11T13:40:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/\"},\"wordCount\":3008,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/\",\"name\":\"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg\",\"datePublished\":\"2023-10-11T13:40:17+00:00\",\"dateModified\":\"2023-10-11T13:40:17+00:00\",\"description\":\"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"lam-tron-so-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-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\":\"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND\"}]},{\"@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\/ba9e95280c202ca5f157d73b65677d10\",\"name\":\"sialthuong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/817d07bcfb6423ad6eec65f2c0b13071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/817d07bcfb6423ad6eec65f2c0b13071?s=96&d=mm&r=g\",\"caption\":\"sialthuong\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/sialthuong\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND","description":"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....","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\/lam-tron-so-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong excel v\u1edbi H\u00e0m ROUND","og_description":"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-10-11T13:40:17+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg","type":"image\/jpeg"}],"author":"sialthuong","twitter_card":"summary_large_image","twitter_title":"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong excel v\u1edbi H\u00e0m ROUND","twitter_description":"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"sialthuong","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"14 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/"},"author":{"name":"sialthuong","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/ba9e95280c202ca5f157d73b65677d10"},"headline":"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND","datePublished":"2023-10-11T13:40:17+00:00","dateModified":"2023-10-11T13:40:17+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/"},"wordCount":3008,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/","name":"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg","datePublished":"2023-10-11T13:40:17+00:00","dateModified":"2023-10-11T13:40:17+00:00","description":"C\u00e1ch v\u1eadn d\u1ee5ng c\u01a1 b\u1ea3n v\u00e0 cao c\u1ea5p v\u1edbi h\u00e0m ROUND, ROUNDUP, ROUNDDOWN v\u00e0 MROUND \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 trong excel. M\u1ed9t v\u00e0i l\u01b0u \u00fd m\u00e0 b\u1ea1n n\u00ean bi\u1ebft....","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/09\/lam-tron-so-trong-excel.jpg","width":1200,"height":628,"caption":"lam-tron-so-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/lam-tron-so-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":"5 C\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi H\u00e0m ROUND"}]},{"@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\/ba9e95280c202ca5f157d73b65677d10","name":"sialthuong","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/817d07bcfb6423ad6eec65f2c0b13071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/817d07bcfb6423ad6eec65f2c0b13071?s=96&d=mm&r=g","caption":"sialthuong"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/sialthuong\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/259992","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=259992"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/259992\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/271341"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=259992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=259992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=259992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}