{"id":13240,"date":"2022-11-25T16:15:28","date_gmt":"2022-11-25T09:15:28","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13240"},"modified":"2022-12-07T14:30:56","modified_gmt":"2022-12-07T07:30:56","slug":"round-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/","title":{"rendered":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;13240&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;12&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.2&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.2\\\/5 - (12 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t&quot;,&quot;width&quot;:&quot;119.3&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 119.3px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.2\/5 - (12 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400; color: #000000;\"><strong>H\u00e0m Round trong Excel<\/strong> l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi h\u1ecdc sinh, sinh vi\u00ean v\u00e0 d\u00e2n v\u0103n ph\u00f2ng. Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi nh\u1eefng tr\u01b0\u1eddng h\u1ee3p c\u1ea7n l\u00e0m tr\u00f2n c\u00e1c ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n ph\u1ee9c t\u1ea1p. H\u00e0m Round ch\u1eafc ch\u1eafn l\u00e0 gi\u1ea3i ph\u00e1p l\u00e0m tr\u00f2n s\u1ed1 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m t\u1ed1i \u0111a th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c t\u00ednh to\u00e1n. H\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft sau c\u1ee7a TEKY \u0111\u1ec3 kh\u00e1m ph\u00e1 h\u00e0m t\u00ednh to\u00e1n n\u00e0y nh\u00e9!<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#Ham_Round_trong_Excel_la_gi\" >H\u00e0m Round trong Excel l\u00e0 g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#Cong_thuc_tinh_Round_trong_Excel\" >C\u00f4ng th\u1ee9c t\u00ednh Round trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#Cach_su_dung_Round_trong_Excel\" >C\u00e1ch s\u1eed d\u1ee5ng Round trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#Mot_so_ham_Round_trong_Excel_lien_quan\" >M\u1ed9t s\u1ed1 h\u00e0m Round trong Excel li\u00ean quan<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#Ham_Roundup\" >H\u00e0m Roundup<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#Ham_Rounddown\" >H\u00e0m Rounddown<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#Ham_MRound\" >H\u00e0m MRound<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Round_trong_Excel_la_gi\"><\/span><span style=\"color: #000000;\"><b>H\u00e0m Round trong Excel l\u00e0 g\u00ec?<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">H\u00e0m Round hay c\u00f2n g\u1ecdi l\u00e0 h\u00e0m Math\/ Trig. H\u00e0m chuy\u00ean d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n m\u1ed9t ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n trong b\u1ea3ng t\u00ednh Excel. V\u1edbi Round, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n \u0111\u1ebfn m\u1ed9t ch\u1eef s\u1ed1 c\u1ee5 th\u1ec3 sang ph\u1ea3i ho\u1eb7c tr\u00e1i c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m ph\u1ed5 bi\u1ebfn trong Excel. H\u00e0m n\u00e0y r\u1ea5t \u0111\u01b0\u1ee3c d\u00e2n v\u0103n ph\u00f2ng \u01b0a chu\u1ed9ng.\u00a0<\/span><\/p>\n<figure id=\"attachment_13242\" aria-describedby=\"caption-attachment-13242\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13242 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-1.jpg\" alt=\"H\u00e0m Round trong Excel l\u00e0 g\u00ec?\" width=\"600\" height=\"408\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-1-400x272.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13242\" class=\"wp-caption-text\">H\u00e0m Round trong Excel l\u00e0 g\u00ec?<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cong_thuc_tinh_Round_trong_Excel\"><\/span><span style=\"color: #000000;\"><b>C\u00f4ng th\u1ee9c t\u00ednh Round trong Excel<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Round trong Excel c\u00f3 c\u00f4ng th\u1ee9c r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u: =ROUND(number, num_digits)<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"H\u00e0m ROUND trong Excel, c\u00e1ch l\u00e0m tr\u00f2n s\u1ed1 trong Excel b\u1eb1ng h\u00e0m ROUND\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/FpotToQDoLI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">C\u00e1c th\u00e0nh ph\u1ea7n n\u00e0y c\u00f3 th\u1ec3 hi\u1ec3u nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Number l\u00e0 m\u1ed9t con s\u1ed1 th\u1ef1c m\u00e0 b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Num_digits ch\u00ednh \u0111\u1ed1i s\u1ed1 c\u00f3 th\u1ec3 \u00e2m ho\u1eb7c d\u01b0\u01a1ng.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Khi x\u00e1c \u0111\u1ecbnh Num_digits, n\u1ebfu nh\u01b0:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Num_digits &gt; 0: Ch\u1ec9 \u0111\u1ecbnh l\u00e0m tr\u00f2n s\u1ed1 ch\u1eef s\u1ed1 \u1edf b\u00ean ph\u1ea3i c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Num_digits = 0: Ch\u1ec9 \u0111\u1ecbnh h\u00e0m l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t c\u1ee7a s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Num_digits &lt; 0: Ch\u1ec9 \u0111\u1ecbnh l\u00e0m tr\u00f2n \u0111\u1ebfn s\u1ed1 ch\u1eef s\u1ed1 \u1edf b\u00ean tr\u00e1i c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n.<\/span><\/li>\n<\/ul>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Cach_su_dung_Round_trong_Excel\"><\/span><span style=\"color: #000000;\"><b>C\u00e1ch s\u1eed d\u1ee5ng Round trong Excel<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Nhi\u1ec1u ng\u01b0\u1eddi ngh\u0129 r\u1eb1ng Round trong Excel r\u1ea5t ph\u1ee9c t\u1ea1p. Tuy nhi\u00ean, h\u00e0m n\u00e0y kh\u00f4ng h\u1ec1 kh\u00f3 nh\u01b0 b\u1ea1n ngh\u0129. N\u1ebfu bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng Round Excel, b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c kh\u00e1 nhi\u1ec1u th\u1eddi gian v\u00e0 \u0111\u01a1n gi\u1ea3n h\u00f3a d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3.<\/span><\/p>\n<figure id=\"attachment_13243\" aria-describedby=\"caption-attachment-13243\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13243 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-2.jpg\" alt=\"C\u00e1ch s\u1eed d\u1ee5ng Round trong Excel\" width=\"600\" height=\"361\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-2-400x241.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13243\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng Round trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">C\u00fa ph\u00e1p c\u1ee7a Round trong Excel nh\u01b0 sau:\u00a0 =ROUND(number,n)<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">Number l\u00e0 s\u1ed1 ch\u00fang ta c\u1ea7n l\u00e0m tr\u00f2n<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">n l\u00e0 m\u1ed9t con s\u1ed1 d\u01b0\u01a1ng ho\u1eb7c \u00e2m<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Ngo\u00e0i ra, v\u1edbi \u0111\u1ed1i s\u1ed1 n, ng\u01b0\u1eddi ta chia ra m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau nh\u01b0 sau:<\/span><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">N\u1ebfu n = 0: ch\u00fang ta s\u1ebd l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ebfn s\u1ed1 nguy\u00ean g\u1ea7n nh\u1ea5t. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m tr\u00f2n s\u1ed1 9.54 th\u00ec ta c\u00f3 c\u00fa ph\u00e1p ROUND(9.54,0) v\u00e0 k\u1ebft qu\u1ea3 s\u1ebd b\u1eb1ng 9.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">N\u1ebfu n &gt; 0: Khi \u0111\u00f3, s\u1ed1 th\u1eadp ph\u00e2n s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn v\u1ecb tr\u00ed \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh. V\u00ed d\u1ee5, n\u1ebfu mu\u1ed1n l\u00e0m tr\u00f2n ROUND(21.25464,5) = 21.25. T\u01b0\u01a1ng t\u1ef1, n\u1ebfu b\u1ea1n ch\u1ecdn n =1 th\u00ec k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 s\u1ebd l\u1ea5y 1 s\u1ed1 l\u1ebb. N\u1ebfu ch\u1ecdn n=2 th\u00ec k\u1ebft qu\u1ea3 l\u1ea5y 2 s\u1ed1 l\u1ebb,\u2026<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400; color: #000000;\">N\u1ebfu n &lt; 0: s\u1ed1 \u0111\u00e3 ch\u1ecdn s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n sang ph\u00eda b\u00ean tr\u00e1i c\u1ee7a d\u1ea5u th\u1eadp ph\u00e2n. V\u00ed d\u1ee5, nh\u1eadp c\u00fa ph\u00e1p ROUND(23.23434, -1) s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 20. Theo quy t\u1eafc n\u00e0y, n\u1ebfu ch\u1ecdn n = -1 th\u00ec s\u1ed1 th\u1eadp ph\u00e2n s\u1ebd \u0111\u01b0\u1ee3c l\u00e0m tr\u00f2n \u0111\u1ebfn h\u00e0ng ch\u1ee5c. N\u1ebfu n = -2 th\u00ec l\u00e0m tr\u00f2n \u0111\u1ebfn tr\u0103m,\u2026<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Nh\u01b0 v\u1eady, c\u00f3 th\u1ec3 th\u1ea5y vi\u1ec7c s\u1eed d\u1ee5ng l\u1ec7nh Round trong Excel s\u1ebd gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng l\u00e0m tr\u00f2n s\u1ed1 li\u1ec7u. \u0110\u1ed3ng th\u1eddi l\u00e0m g\u1ecdn b\u1ea3ng t\u00ednh h\u01a1n thay v\u00ec gi\u1eef nguy\u00ean nhi\u1ec1u s\u1ed1 l\u1ebb ph\u00eda sau s\u1ed1 th\u1eadp ph\u00e2n. Nh\u1edd \u0111\u00f3, ng\u01b0\u1eddi xem c\u00f3 th\u1ec3 theo d\u00f5i b\u1ea3ng d\u1eef li\u1ec7u Excel m\u1ed9t c\u00e1ch tr\u1ef1c quan v\u00e0 nhanh ch\u00f3ng. Ngo\u00e0i ra, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m li\u00ean quan \u0111\u1ebfn Round nh\u01b0 : Roundup, Rounddown v\u00e0 MRound.\u00a0<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Mot_so_ham_Round_trong_Excel_lien_quan\"><\/span><span style=\"color: #000000;\"><b>M\u1ed9t s\u1ed1 h\u00e0m Round trong Excel li\u00ean quan<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Roundup\"><\/span><span style=\"color: #000000;\"><b>H\u00e0m Roundup<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">V\u1edbi h\u00e0m Roundup, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n l\u00ean gi\u00e1 tr\u1ecb cao h\u01a1n s\u1ed1 ban \u0111\u1ea7u. Gi\u00e1 tr\u1ecb cao h\u01a1n s\u1ebd ph\u1ee5 thu\u1ed9c v\u00e0o vi\u1ec7c b\u1ea1n d\u00f9ng h\u00e0m n\u00e0y nh\u01b0 th\u1ebf n\u00e0o. C\u00f3 th\u1ec3 hi\u1ec3u nh\u01b0 sau, n\u1ebfu s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n cho m\u1ed9t gi\u00e1 tr\u1ecb d\u01b0\u01a1ng th\u00ec s\u1ed1 ph\u00eda sau s\u1ebd \u0111\u1ea9y gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0m tr\u00f2n l\u00ean tr\u00ean h\u00e0ng th\u1eadp ph\u00e2n.<\/span><\/p>\n<figure id=\"attachment_13244\" aria-describedby=\"caption-attachment-13244\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13244\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-3-400x177.png\" alt=\"H\u00e0m Roundup\" width=\"600\" height=\"266\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-3-400x177.png 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-3.png 600w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13244\" class=\"wp-caption-text\">H\u00e0m Roundup<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n c\u00f3 gi\u00e1 tr\u1ecb \u00e2m, th\u00ec s\u1ebd l\u00e0m tr\u00f2n l\u00ean h\u00e0ng ch\u1ee5c ho\u1eb7c h\u00e0ng tr\u0103m theo c\u00fa ph\u00e1p sau \u0111\u00e2y:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"><b>= ROUNDUP(s\u1ed1 l\u00e0m tr\u00f2n, gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n)<\/b><\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_Rounddown\"><\/span><span style=\"color: #000000;\"><b>H\u00e0m Rounddown<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Ng\u01b0\u1ee3c l\u1ea1i so v\u1edbi h\u00e0m Roundup, h\u00e0m Rounddown \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb g\u1ed1c theo nh\u1eefng y\u00eau c\u1ea7u ph\u00f9 h\u1ee3p. Khi \u0111\u00f3, k\u1ebft qu\u1ea3 c\u1ee7a s\u1ed1 l\u00e0m tr\u00f2n s\u1ebd t\u00f9y thu\u1ed9c v\u00e0o c\u00e1ch \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"><b>= ROUNDDOWN(s\u1ed1 l\u00e0m tr\u00f2n, gi\u00e1 tr\u1ecb c\u1ea7n l\u00e0m tr\u00f2n)<\/b><\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ham_MRound\"><\/span><span style=\"color: #000000;\"><b>H\u00e0m MRound<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">V\u1edbi h\u00e0m MRound, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m tr\u00f2n s\u1ed1 th\u1eadp ph\u00e2n \u0111\u1ebfn b\u1ed9i s\u1ed1 c\u1ee7a m\u1ed9t th\u00f4ng s\u1ed1 d\u1eef li\u1ec7u kh\u00e1c c\u00f3 trong b\u1ea3ng t\u00ednh. \u1ede \u0111\u00e2y, Multiplecos ngh\u0129a l\u00e0 s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n t\u00ednh b\u1eb1ng b\u1ed9i v\u00e0 Number ch\u00ednh l\u00e0 gi\u00e1 tr\u1ecb l\u00e0m tr\u00f2n. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u1ea7n \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n sau \u0111\u00e2y:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"color: #000000;\"><b>=MROUND(gi\u00e1 tr\u1ecb s\u1ed1 l\u00e0m tr\u00f2n,s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n t\u00ednh b\u1eb1ng b\u1ed9i)<\/b><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Tuy nhi\u00ean, khi \u00e1p d\u1ee5ng cho 2 s\u1ed1 Number v\u00e0 Multiple kh\u00e1c d\u1ea5u, k\u1ebft qu\u1ea3 cho ra s\u1ebd sai v\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb k\u00ed hi\u1ec7u #NUM. 2 s\u1ed1 kh\u00e1c d\u1ea5u \u1edf \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 Number mang d\u1ea5u \u00e2m v\u00e0 Multiple mang d\u1ea5u d\u01b0\u01a1ng. V\u00ed d\u1ee5, =MROUND(-77;98)=#Num\/Sai. M\u1eb7t kh\u00e1c, n\u1ebfu k\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c b\u1eb1ng 0,5 th\u00ec s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n &lt; 0,5 s\u1ebd nh\u1ecf v\u00e0 s\u1ed1 l\u00e0m tr\u00f2n s\u1ebd l\u1edbn khi s\u1ed1 c\u1ea7n l\u00e0m tr\u00f2n &gt;0,5.<\/span><\/p>\n<figure id=\"attachment_13245\" aria-describedby=\"caption-attachment-13245\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13245 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-4.jpg\" alt=\"H\u00e0m MRound\" width=\"600\" height=\"310\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel-4-400x207.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-13245\" class=\"wp-caption-text\">H\u00e0m MRound<\/figcaption><\/figure>\n<p><strong>XEM TH\u00caM: <\/strong><\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/ham-ngay-thang-nam-trong-excel\/\"><strong>H\u00e9 l\u1ed9 h\u00e0m ng\u00e0y th\u00e1ng n\u0103m trong Excel v\u00e0 nh\u1eefng \u0111i\u1ec1u n\u00ean bi\u1ebft<\/strong><\/a><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><a style=\"color: #0000ff;\" href=\"https:\/\/teky.edu.vn\/blog\/cach-khoa-cot-trong-excel\/\"><strong>B\u1eadt m\u00ed c\u00e1ch kh\u00f3a c\u1ed9t trong Excel ch\u1ec9 trong m\u1ed9t n\u1ed1t nh\u1ea1c<\/strong><\/a><\/span><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-cach-su-dung-ham-lam-tron-trong-excel-chi-tiet\/\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m l\u00e0m tr\u00f2n trong Excel chi ti\u1ebft<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-ve-bieu-do-tron-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong excel \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400; color: #000000;\">Nh\u01b0 v\u1eady, Teky v\u1eeba c\u00f9ng b\u1ea1n gi\u1ea3i m\u00e3 v\u00e0 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng Round trong Excel. C\u00e1c h\u00e0m t\u00ednh to\u00e1n trong Excel tr\u01b0\u1edbc nay v\u1eeba l\u00e0 c\u00f4ng c\u1ee5 ti\u1ec7n \u00edch nh\u01b0ng c\u0169ng l\u00e0 n\u1ed7i \u201c\u00e1m \u1ea3nh\u201d c\u1ee7a nh\u1eefng ng\u01b0\u1eddi kh\u00f4ng th\u00f4ng th\u1ea1o tin h\u1ecdc. Tuy nhi\u00ean, v\u1edbi nh\u1eefng h\u01b0\u1edbng d\u1eabn d\u00f9ng Round \u0111\u01a1n gi\u1ea3n v\u00e0 chi ti\u1ebft m\u00e0 Teky v\u1eeba chia s\u1ebb,\u00a0 ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd c\u00f3 th\u1ec3 t\u1ef1 tin d\u00f9ng h\u00e0m Round \u0111\u1ec3 gi\u1ea3i quy\u1ebft h\u00e0ng t\u00e1 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n ph\u1ee9c t\u1ea1p trong b\u1ea3ng t\u00ednh Excel!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Round trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 kh\u00f4ng th\u1ec3 thi\u1ebfu \u0111\u1ed1i v\u1edbi h\u1ecdc sinh, sinh vi\u00ean v\u00e0 d\u00e2n v\u0103n ph\u00f2ng. Khi l\u00e0m vi\u1ec7c v\u1edbi Excel, b\u1ea1n kh\u00f4ng th\u1ec3 tr\u00e1nh kh\u1ecfi nh\u1eefng tr\u01b0\u1eddng h\u1ee3p c\u1ea7n l\u00e0m tr\u00f2n c\u00e1c ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n ph\u1ee9c t\u1ea1p. H\u00e0m Round ch\u1eafc ch\u1eafn l\u00e0 gi\u1ea3i ph\u00e1p l\u00e0m tr\u00f2n s\u1ed1 gi\u00fap &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13241,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13240","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft sau. C\u00f9ng theo d\u00f5i ngay th\u00f4ng tin chi ti\u1ebft b\u00ean d\u01b0\u1edbi nehs!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft sau. C\u00f9ng theo d\u00f5i ngay th\u00f4ng tin chi ti\u1ebft b\u00ean d\u01b0\u1edbi nehs!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-25T09:15:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-07T07:30:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"289\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t\",\"datePublished\":\"2022-11-25T09:15:28+00:00\",\"dateModified\":\"2022-12-07T07:30:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/\"},\"wordCount\":1628,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/\",\"name\":\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png\",\"datePublished\":\"2022-11-25T09:15:28+00:00\",\"dateModified\":\"2022-12-07T07:30:56+00:00\",\"description\":\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft sau. C\u00f9ng theo d\u00f5i ngay th\u00f4ng tin chi ti\u1ebft b\u00ean d\u01b0\u1edbi nehs!\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png\",\"width\":600,\"height\":289,\"caption\":\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t","description":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft sau. C\u00f9ng theo d\u00f5i ngay th\u00f4ng tin chi ti\u1ebft b\u00ean d\u01b0\u1edbi nehs!","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:\/\/teky.edu.vn\/blog\/round-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t","og_description":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft sau. C\u00f9ng theo d\u00f5i ngay th\u00f4ng tin chi ti\u1ebft b\u00ean d\u01b0\u1edbi nehs!","og_url":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-25T09:15:28+00:00","article_modified_time":"2022-12-07T07:30:56+00:00","og_image":[{"width":600,"height":289,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png","type":"image\/png"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"6 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t","datePublished":"2022-11-25T09:15:28+00:00","dateModified":"2022-12-07T07:30:56+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/"},"wordCount":1628,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/","name":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png","datePublished":"2022-11-25T09:15:28+00:00","dateModified":"2022-12-07T07:30:56+00:00","description":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t s\u1ebd c\u00f3 trong b\u00e0i vi\u1ebft sau. C\u00f9ng theo d\u00f5i ngay th\u00f4ng tin chi ti\u1ebft b\u00ean d\u01b0\u1edbi nehs!","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/round-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/round-trong-excel.png","width":600,"height":289,"caption":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/round-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"H\u00e0m round trong Excel v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng chi ti\u1ebft nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=13240"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13240\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13241"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}