{"id":12110,"date":"2025-01-15T07:11:56","date_gmt":"2025-01-15T07:11:56","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rand-huong-dan-su-dung-ham-rand-trong-excel\/"},"modified":"2025-01-15T07:11:56","modified_gmt":"2025-01-15T07:11:56","slug":"ham-rand-huong-dan-su-dung-ham-rand-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-rand-huong-dan-su-dung-ham-rand-trong-excel\/","title":{"rendered":"H\u00e0m RAND, h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m RAND trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em><strong>H\u00e0m RAND() \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean. \u0110\u00f3 c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 th\u1ef1c ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n 0 v\u00e0 nh\u1ecf h\u01a1n m\u1ed9t s\u1ed1 b\u1ea5t k\u00ec n\u00e0o \u0111\u00f3 hay l\u00e0 m\u1ed9t ch\u1eef c\u00e1i thu\u1ed9c b\u1ea3n Alphabet \u2026<\/strong><\/em><\/p>\n<p style=\"text-align: justify\"><strong>C\u00fa ph\u00e1p:\u00a0<\/strong><strong>= RAND()<\/strong><\/p>\n<p>\u0110\u00e2y l\u00e0 h\u00e0m kh\u00f4ng ch\u01b0a tham s\u1ed1.<\/p>\n<p><strong>V\u00ed d\u1ee5<\/strong><\/p>\n<ul>\n<li>Mu\u1ed1n l\u1ea5y m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n 0 v\u00e0 nh\u1ecf h\u01a1n 1, d\u00f9ng c\u00f4ng th\u1ee9c: =<strong>RAND()<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4239 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rand.png\" width=\"600\" height=\"490\" title=\"ham-rand\"><\/p>\n<ul>\n<li>Mu\u1ed1n l\u1ea5y m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0 v\u00e0 nh\u1ecf h\u01a1n n, d\u00f9ng c\u00f4ng th\u1ee9c:\u00a0<strong>=RAND() * n<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4240 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rand-1-1.png\" width=\"600\" height=\"476\" title=\"ham-rand-1-1\"><\/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\u00e0m RANDOM<\/strong><\/a>\u00a0ngo\u00e0i vi\u1ec7c cho k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t con s\u1ed1 ng\u1eabu nhi\u00ean th\u00ec h\u00e0m c\u0169ng c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean.<\/p>\n<ul>\n<li>Mu\u1ed1n l\u1ea5y m\u1ed9t k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean trong b\u1ea3ng ch\u1eef c\u00e1i ti\u1ebfng Anh. Bi\u1ebft b\u1ea3ng ch\u1eef c\u00e1i ti\u1ebfng Anh c\u00f3 26 ch\u1eef c\u00e1i n\u00ean \u0111\u1ea7u ti\u00ean c\u00e1c b\u1ea1n c\u1ea7n l\u1ea5y m\u1ed9t s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean gi\u1eefa 1 v\u00e0 26 v\u1edbi c\u00f4ng th\u1ee9c:\u00a0<strong>=INT(RAND() * 26 + 1)<\/strong><\/li>\n<\/ul>\n<ul>\n<li>Mu\u1ed1n tr\u1ea3 v\u1ec1 m\u1ed9t ch\u1eef c\u00e1i n\u1eb1m trong b\u1ea3ng ch\u1eef c\u00e1i Alphabet. \u0110\u01b0\u1ee3c bi\u1ebft, theo b\u1ea3ng m\u00e3 ANSI, nh\u1eefng k\u00fd t\u1ef1 vi\u1ebft hoa (A t\u1edbi Z) n\u1eb1m t\u1eeb m\u00e3 ANSI <strong>65<\/strong> \u0111\u1ebfn m\u00e3 ANSI <strong>90<\/strong>. D\u00f9ng h\u00e0m <strong>CHAR()\u00a0<\/strong>v\u1edbi c\u00f4ng th\u1ee9c:\u00a0<strong>=CHAR(INT(RAND() * 26 + 1) + 64)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4241 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rand-2-1.png\" width=\"600\" height=\"471\" title=\"ham-rand-2-1\"><\/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-352.gif\" title=\"ex101_92019-nho-352\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>T\u01b0\u01a1ng t\u1ef1, n\u1ebfu l\u00e0 ch\u1eef c\u00e1i ng\u1eabu nhi\u00ean l\u00e0 ch\u1eef th\u01b0\u1eddng t\u1eeb a t\u1edbi z n\u1eb1m t\u1eeb m\u00e3 ANSI <strong>97<\/strong> \u0111\u1ebfn m\u00e3 ANSI <strong>122,<\/strong> d\u00f9ng h\u00e0m CHAR() v\u1edbi c\u00f4ng th\u1ee9c:\u00a0<strong>=CHAR(INT(RAND() * 26 + 1) + 96)<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4242 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rand-3.png\" width=\"600\" height=\"464\" title=\"ham-rand-3\"><\/p>\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o Excel, b\u1ea1n kh\u00f4ng ch\u1ec9 s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m m\u00e0 c\u00f2n c\u1ea7n bi\u1ebft v\u00e0 s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c th\u1ee7 thu\u1eadt c\u1ee7a Excel. Ngo\u00e0i ra, b\u1ea1n kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng th\u00e0nh th\u1ea1o n\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c h\u1ecdc m\u1ed9t c\u00e1ch c\u00f3 h\u1ec7 th\u1ed1ng, logic. \u0110\u1eebng lo l\u1eafng, H\u1ecdc Excel Online s\u1ebd gi\u00fap b\u1ea1n chinh ph\u1ee5c Excel, bi\u1ebfn Excel th\u00e0nh c\u00f4ng c\u1ee5 h\u1eefu hi\u1ec7u gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00f4ng vi\u1ec7c nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3 v\u00e0 th\u00f4ng minh.<\/p>\n<p>Hi\u1ec7n t\u1ea1i, <a href=\"http:\/\/blog.ezworkapp.com\/\">H\u1ecdc Excel Online<\/a> c\u00f3 kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2w6YAe8\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>.\u00a0\u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c Excel m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: HocExcel.Online<\/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-352.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12111,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12110","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\/12110","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=12110"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12110\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12111"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}