{"id":9265,"date":"2025-01-01T23:53:36","date_gmt":"2025-01-01T23:53:36","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-ham-randbetween-chon-so-ngau-nhien-trong-excel\/"},"modified":"2025-01-01T23:53:36","modified_gmt":"2025-01-01T23:53:36","slug":"huong-dan-ham-randbetween-chon-so-ngau-nhien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-ham-randbetween-chon-so-ngau-nhien-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn h\u00e0m RANDBETWEEN ch\u1ecdn s\u1ed1 ng\u1eabu nhi\u00ean trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong Excel, c\u00f3 nh\u1eefng tr\u01b0\u1eddng h\u1ee3p nh\u01b0 khi c\u1ea7n t\u1ea1o m\u1eabu d\u1eef li\u1ec7u h\u00e0ng lo\u1ea1t, b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng t\u1edbi nh\u1eefng con s\u1ed1 ng\u1eabu nhi\u00ean. <strong>H\u00e0m RANDBETWEEN<\/strong> s\u1ebd gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6775d57fe5d49\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/ham-randbetween-chon-ngau-nhien-trong-excel.html#Ham_RANDBETWEEN_cong_dung_va_cu_phap\" title=\"H\u00e0m RANDBETWEEN, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m RANDBETWEEN, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/ham-randbetween-chon-ngau-nhien-trong-excel.html#Cong_dung_ham_RANDBETWEEN\" title=\"C\u00f4ng d\u1ee5ng h\u00e0m RANDBETWEEN\">C\u00f4ng d\u1ee5ng h\u00e0m RANDBETWEEN<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/ham-randbetween-chon-ngau-nhien-trong-excel.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/ham-randbetween-chon-ngau-nhien-trong-excel.html#Ung_dung_thuc_te\" title=\"\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf\">\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ham-randbetween-chon-ngau-nhien-trong-excel.html#Cach_ngan_RAND_va_RANDBETWEEN_tinh_toan_lai\" title=\"C\u00e1ch ng\u0103n RAND v\u00e0 RANDBETWEEN t\u00ednh to\u00e1n l\u1ea1i\">C\u00e1ch ng\u0103n RAND v\u00e0 RANDBETWEEN t\u00ednh to\u00e1n l\u1ea1i<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_RANDBETWEEN_cong_dung_va_cu_phap\"><\/span>H\u00e0m RANDBETWEEN, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_dung_ham_RANDBETWEEN\"><\/span>C\u00f4ng d\u1ee5ng h\u00e0m RANDBETWEEN<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m RANDBETWEEN tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean n\u0103\u0300m gi\u1eefa c\u00e1c s\u1ed1 do b\u1ea1n ch\u1ec9 \u0111\u1ecbnh. M\u00f4\u0303i khi trang ti\u0301nh \u0111\u01b0\u01a1\u0323c ti\u0301nh toa\u0301n, s\u1ed1 nguy\u00ean \u0111\u00f3 l\u1ea1i thay \u0111\u1ed5i m\u1ed9t l\u1ea7n.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span>C\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m RANDBETWEEN c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=RANDBETWEEN(bottom,top)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3:<\/p>\n<p><strong>bottom<\/strong> l\u00e0 gi\u1edbi h\u1ea1n \u0111\u1ea7u s\u1ed1 nguy\u00ean b\u1ea1n mu\u1ed1n<\/p>\n<p><strong>top\u00a0<\/strong>l\u00e0 gi\u1edbi h\u1ea1n cu\u1ed1i s\u1ed1 nguy\u00ean<\/p>\n<p>Gi\u00e1 tr\u1ecb t\u1eeb RANDBETWEEN s\u1ebd \u0111\u01b0\u1ee3c l\u1ea5y ra ng\u1eabu nhi\u00ean trong kho\u1ea3ng\u00a0<strong>[bottom;top]<\/strong> &lt;bao g\u1ed3m c\u1ea3 bottom v\u00e0 top&gt;<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ung_dung_thuc_te\"><\/span>\u1ee8ng d\u1ee5ng th\u1ef1c t\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong th\u1ef1c t\u1ebf, h\u00e0m RANDBETWEEN c\u00f3 v\u00f4 v\u00e0n \u1ee9ng d\u1ee5ng t\u00f9y thu\u1ed9c v\u00e0o n\u1ed9i dung c\u00f4ng vi\u1ec7c v\u00e0 \u00fd t\u01b0\u1edfng t\u1eebng ng\u01b0\u1eddi. <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n 2 \u1ee9ng d\u1ee5ng c\u01a1 b\u1ea3n nh\u1ea5t c\u1ee7a h\u00e0m RANDBETWEEN<\/p>\n<p><strong>S\u1eed d\u1ee5ng RANDBETWEEN t\u1ea1o d\u1eef li\u1ec7u m\u1eabu<\/strong><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-30.gif\" title=\"ex101_92019-nho-30\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p y\u00eau c\u1ea7u d\u1eef li\u1ec7u m\u1eabu (c\u00e1c b\u00e0i ki\u1ec3m tra, c\u00e1c d\u1eef li\u1ec7u m\u1eadt\u2026) ta c\u00f3 th\u1ec3 thay \u0111\u1ed5i s\u1ed1 li\u1ec7u th\u00f4ng qua RANDBETWEEN:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25100\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-randbetween-1.png\" width=\"437\" height=\"161\" title=\"ham-randbetween-1\"><\/p>\n<p><strong>S\u1eed d\u1ee5ng RANDBETWEEN\u00a0<\/strong><strong>k\u1ebft h\u1ee3p c\u00e1c h\u00e0m \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean<\/strong><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng RANDBETWEEN k\u1ebft h\u1ee3p c\u00e1c h\u00e0m nh\u01b0 VLOOKUP, INDEX\/MATCH\u2026 \u0111\u1ec3 l\u1ea5y ra gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_ngan_RAND_va_RANDBETWEEN_tinh_toan_lai\"><\/span>C\u00e1ch ng\u0103n RAND v\u00e0 RANDBETWEEN t\u00ednh to\u00e1n l\u1ea1i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean, ng\u00e0y ho\u1eb7c chu\u1ed7i v\u0103n b\u1ea3n c\u1ed1 \u0111\u1ecbnh kh\u00f4ng thay \u0111\u1ed5i m\u1ed7i khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c t\u00ednh l\u1ea1i, h\u00e3y s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c k\u1ef9 thu\u1eadt sau:<\/p>\n<ol style=\"text-align: justify\">\n<li>\u0110\u1ec3 h\u00e0m RAND ho\u1eb7c RANDBETWEEN d\u1eebng t\u00ednh to\u00e1n l\u1ea1i trong\u00a0<strong>m\u1ed9t \u00f4<\/strong>, h\u00e3y ch\u1ecdn \u00f4 \u0111\u00f3, chuy\u1ec3n sang thanh c\u00f4ng th\u1ee9c v\u00e0 nh\u1ea5n\u00a0F9\u00a0\u0111\u1ec3 thay th\u1ebf c\u00f4ng th\u1ee9c b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3.<\/li>\n<li>\u0110\u1ec3 ng\u0103n ch\u1eb7n m\u1ed9t h\u00e0m ng\u1eabu nhi\u00ean c\u1ee7a Excel t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt c\u00e1c gi\u00e1 tr\u1ecb trong\u00a0<strong>m\u1ed9t s\u1ed1 \u00f4<\/strong>, h\u00e3y s\u1eed d\u1ee5ng\u00a0<em>paste Special <\/em>\u00a0Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 v\u1edbi c\u00f4ng th\u1ee9c ng\u1eabu nhi\u00ean, nh\u1ea5n\u00a0Ctrl + C\u00a0\u0111\u1ec3 sao ch\u00e9p ch\u00fang, sau \u0111\u00f3 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o d\u00e3y \u0111\u00e3 ch\u1ecdn v\u00e0 nh\u1ea5n\u00a0<em>Paste Special<\/em>\u00a0&gt;\u00a0<em>Values<\/em>\u00a0.\u00a0Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n\u00a0Shift + F10\u00a0v\u00e0 sau \u0111\u00f3\u00a0V\u00a0, l\u00e0 ph\u00edm t\u1eaft cho\u00a0t\u00f9y ch\u1ecdn\u00a0\u201d\u00a0<em>Paste special &gt;Values <\/em>.<\/li>\n<\/ol>\n<p>C\u1ee5 th\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o 2 b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<br \/>\n<strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-tao-du-lieu-ngau-nhien-tu-dong-trong-excel-voi-ham-vlookup-randbetween.html\">H\u01b0\u1edbng d\u1eabn t\u1ea1o d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean t\u1ef1 \u0111\u1ed9ng b\u1eb1ng VLOOKUP v\u00e0 RANDBETWEEN<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chon-ngau-nhien-nhieu-o-tu-mot-cot.html\"><strong>H\u01b0\u1edbng d\u1eabn ch\u1ecdn ng\u1eabu nhi\u00ean 1 \u00f4 t\u1eeb 1 c\u1ed9t<\/strong><\/a><\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o? Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft li\u00ean quan v\u1ec1 c\u00e1c h\u00e0m kh\u00e1c nh\u01b0:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien.html\"><strong>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m RAND\/RANBETWEEN trong Excel<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tim-hieu-ve-cac-ham-lam-tron-so-trong-excel-va-cac-nguyen-tac-lam-tron-so.html\"><strong>L\u00e0m tr\u00f2n s\u1ed1 trong Excel v\u1edbi h\u00e0m ROUND<\/strong><\/a><\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-30.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9266,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9265","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=9265"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9265\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9266"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}