{"id":9269,"date":"2025-01-02T00:05:38","date_gmt":"2025-01-02T00:05:38","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien\/"},"modified":"2025-01-02T00:05:38","modified_gmt":"2025-01-02T00:05:38","slug":"huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANDOM trong Excel \u2013 h\u00e0m t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>\u0110\u1ec3 t\u1ea1o ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean (random) trong Excel, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 h\u00e0m c\u00f3 s\u1eb5n trong Excel. Trong b\u00e0i vi\u1ebft n\u00e0y h\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u hai h\u00e0m thu\u1ed9c nh\u00f3m <strong>h\u00e0m RANDOM<\/strong> trong\u00a0Excel l\u00e0 h\u00e0m RAND v\u00e0 RANDBETWEEN<\/em><\/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-6775d851d818f\" 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<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien.html#Ham_RAND_tao_so_ngau_nhien_tu_0_toi_1\" title=\"H\u00e0m RAND t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 0 t\u1edbi 1\">H\u00e0m RAND t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 0 t\u1edbi 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien.html#Ham_RANDBETWEEN_tao_so_ngau_nhien_trong_khoang\" title=\"H\u00e0m RANDBETWEEN t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng\">H\u00e0m RANDBETWEEN t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-su-dung-ham-random-trong-excel-ham-tao-so-ngau-nhien.html#Nang_cao_kien_thuc_ve_tao_so_ngau_nhien_trong_Excel\" title=\"N\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong\u00a0Excel:\">N\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong\u00a0Excel:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_RAND_tao_so_ngau_nhien_tu_0_toi_1\"><\/span>H\u00e0m RAND t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 0 t\u1edbi 1<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m RAND\u00a0\u0111\u01b0\u1ee3c vi\u1ebft t\u1eaft cho t\u1eeb RANDOM, c\u00f3 ngh\u0129a l\u00e0 ng\u1eabu nhi\u00ean. Tuy nhi\u00ean <strong>h\u00e0m RAND<\/strong> ch\u1ec9 l\u1ea5y ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 0 t\u1edbi 1. C\u00e1ch d\u00f9ng <strong>h\u00e0m RAND<\/strong> nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=RAND()<\/p>\n<p>H\u00e0m n\u00e0y kh\u00f4ng c\u1ea7n tham s\u1ed1, ch\u1ec9 c\u1ea7n ghi t\u00ean h\u00e0m,\u00a0m\u1edf ngo\u1eb7c \u0111\u01a1n r\u1ed3i \u0111\u00f3ng ngo\u1eb7c\u00a0\u0111\u01a1n ngay. K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m RAND s\u1ebd l\u00e0 m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean x m\u00e0 0&lt;x&lt;1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25057\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/vi-du-ve-ham-rand.png\" width=\"403\" height=\"130\" title=\"vi-du-ve-ham-rand\"><\/p>\n<p>\u0110\u1eb7c\u00a0\u0111i\u1ec3m c\u1ee7a h\u00e0m n\u00e0y l\u00e0:<\/p>\n<ul>\n<li>s\u1ed1 ng\u1eabu nhi\u00ean s\u1ebd lu\u00f4n t\u1ef1\u00a0\u0111\u1ed9ng thay\u00a0\u0111\u1ed5i sang 1 s\u1ed1 kh\u00e1c m\u1ed7i khi file\u00a0Excel th\u1ef1c hi\u1ec7n 1 ph\u00e9p t\u00ednh b\u1ea5t k\u1ef3 (hay nh\u1eadp d\u1eef li\u1ec7u m\u1edbi v\u00e0o file trong ch\u1ebf\u00a0\u0111\u1ed9 t\u00ednh to\u00e1n t\u1ef1\u00a0\u0111\u1ed9ng)<\/li>\n<li>S\u1ed1 ng\u1eabu nhi\u00ean lu\u00f4n l\u00e0 s\u1ed1 l\u1ebb<\/li>\n<\/ul>\n<p>Mu\u1ed1n t\u00ecm hi\u1ec3u c\u00e1ch chuy\u1ec3n s\u1ed1 ng\u1eabu nhi\u00ean v\u1ec1 s\u1ed1 nguy\u00ean, s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n 0, t\u1ea1o k\u00fd t\u1ef1 ch\u1eef c\u00e1i ng\u1eabu nhi\u00ean, m\u1eddi c\u00e1c b\u1ea1n xem t\u1ea1i b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-rand-random-trong-excel.html\">H\u00e0m RAND, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m RAND trong Excel<\/a><\/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-31.gif\" title=\"ex101_92019-nho-31\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Ham_RANDBETWEEN_tao_so_ngau_nhien_trong_khoang\"><\/span>H\u00e0m RANDBETWEEN t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u1ea1o ra 1 s\u1ed1 ng\u1eabu nhi\u00ean trong 1 kho\u1ea3ng (t\u1eeb s\u1ed1 A t\u1edbi s\u1ed1 B) th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m RANDBETWEEN. C\u00e1ch d\u00f9ng nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25059\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-randbetween-tao-so-ngau-nhien-trong-khoang.png\" width=\"635\" height=\"148\" title=\"ham-randbetween-tao-so-ngau-nhien-trong-khoang\"><\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m RANDBETWEEN(S\u1ed1\u00a0\u0111\u1ea7u, s\u1ed1 cu\u1ed1i)<\/p>\n<p>\u0110\u1eb7c \u0111i\u1ec3m c\u1ee7a h\u00e0m RANDBETWEEN:<\/p>\n<ul>\n<li>S\u1ed1\u00a0\u0111\u1ea7u ph\u1ea3i nh\u1ecf h\u01a1n s\u1ed1 cu\u1ed1i, kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1\u00a0\u00e2m hay s\u1ed1 d\u01b0\u01a1ng, s\u1ed1 c\u00f3 ph\u1ea7n th\u1eadp ph\u00e2n hay kh\u00f4ng.<\/li>\n<li>K\u1ebft qu\u1ea3 lu\u00f4n l\u00e0 1 s\u1ed1 nguy\u00ean<\/li>\n<\/ul>\n<p>Nguy\u00ean t\u1eafc t\u00ednh c\u1ee7a <strong>h\u00e0m RANDBETWEEN<\/strong>:<\/p>\n<blockquote>\n<p>Gi\u00e1 tr\u1ecb t\u1ea1o ra b\u1edfi RandBetween = (S\u1ed1\u00a0cu\u1ed1i\u00a0\u2013 S\u1ed1 \u0111\u1ea7u)*S\u1ed1 ng\u1eabu nhi\u00ean + S\u1ed1\u00a0\u0111\u1ea7u<\/p>\n<\/blockquote>\n<p>Nh\u01b0 v\u1eady v\u1edbi 2 h\u00e0m RAND v\u00e0 RANDBETWEEN, ch\u00fang ta ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 t\u1ea1o ra\u00a0\u0111\u01b0\u1ee3c nh\u1eefng s\u1ed1 ng\u1eabu nhi\u00ean trong\u00a0Excel m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng.<\/p>\n<p><strong>S\u1eed d\u1ee5ng RANDBETWEEN t\u1ea1o d\u1eef li\u1ec7u m\u1eabu<\/strong><\/p>\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-1.png\" width=\"437\" height=\"161\" title=\"ham-randbetween-1-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><span class=\"ez-toc-section\" id=\"Nang_cao_kien_thuc_ve_tao_so_ngau_nhien_trong_Excel\"><\/span>N\u00e2ng cao ki\u1ebfn th\u1ee9c v\u1ec1 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong\u00a0Excel:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ngo\u00e0i ra b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng VBA\u00a0\u0111\u1ec3 vi\u1ebft\u00a0ra c\u00e1c macro t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean n\u1eefa\u00a0\u0111\u00f3:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-su-dung-ham-tao-so-ngau-nhien-trong-vba-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean trong VBA Excel<\/a><\/p>\n<p>\u0110\u1ec3 bi\u1ebft h\u00e0m t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean\u00a0\u0111\u01b0\u1ee3c\u00a0\u1ee9ng d\u1ee5ng nh\u01b0 th\u1ebf n\u00e0o trong th\u1ef1c t\u1ebf, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u trong b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><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 trong excel v\u1edbi h\u00e0m vlookup randbetween<\/a><\/p>\n<p>\u0110\u1ec3 t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng nhau, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u t\u1ea1i b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/cach-tao-tu-nhien-ngau-nhien-khong-trung-trong-khoang.html\">C\u00e1ch t\u1ea1o s\u1ed1 t\u1ef1 nhi\u00ean ng\u1eabu nhi\u00ean kh\u00f4ng tr\u00f9ng trong kho\u1ea3ng<\/a><\/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-31.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9270,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9269","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\/9269","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=9269"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9269\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9270"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}