{"id":7405,"date":"2024-12-21T17:32:19","date_gmt":"2024-12-21T17:32:19","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween\/"},"modified":"2024-12-21T17:32:19","modified_gmt":"2024-12-21T17:32:19","slug":"tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween\/","title":{"rendered":"T\u1ea1o ng\u00e0y th\u00e1ng, m\u1eadt kh\u1ea9u, chu\u1ed7i v\u0103n b\u1ea3n ng\u1eabu nhi\u00ean b\u1eb1ng h\u00e0m RAND v\u00e0 RANDBETWEEN"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>H\u01b0\u1edbng d\u1eabn n\u00e0y gi\u1ea3i th\u00edch c\u00e1c \u0111\u1eb7c tr\u01b0ng c\u1ee7a thu\u1eadt to\u00e1n t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean c\u1ee7a Excel v\u00e0 ch\u1ec9 ra c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c <a href=\"http:\/\/blog.ezworkapp.com\/ham-rand-random-trong-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\">h\u00e0m RAND<\/a> v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-randbetween-chon-ngau-nhien-trong-excel.html\"><strong>RANDBETWEEN<\/strong><\/a> trong Excel \u0111\u1ec3 t\u1ea1o ra c\u00e1c s\u1ed1, ng\u00e0y th\u00e1ng, m\u1eadt kh\u1ea9u v\u00e0 c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n ng\u1eabu nhi\u00ean kh\u00e1c.<\/em><\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc khi ch\u00fang ta nghi\u00ean c\u1ee9u c\u00e1c k\u1ef9 thu\u1eadt t\u1ea1o ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean kh\u00e1c nhau trong Excel, ch\u00fang ta h\u00e3y x\u00e1c \u0111\u1ecbnh ch\u00fang l\u00e0 g\u00ec.\u00a0N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean l\u00e0 m\u1ed9t chu\u1ed7i c\u00e1c con s\u1ed1, ch\u1eef c\u00e1i ho\u1eb7c c\u00e1c k\u00fd hi\u1ec7u kh\u00f4ng c\u00f3 khu\u00f4n m\u1eabu.<\/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-6766fba22adf3\" 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\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Ham_RAND_%E2%80%93_tao_ra_so_ngau_nhien_thuc\" title=\"H\u00e0m RAND \u2013 t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean th\u1ef1c\">H\u00e0m RAND \u2013 t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean th\u1ef1c<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Cong_thuc_1_Xac_dinh_gia_tri_gioi_han_tren_cua_dai\" title=\"C\u00f4ng th\u1ee9c 1. X\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n tr\u00ean c\u1ee7a d\u1ea3i:\">C\u00f4ng th\u1ee9c 1. X\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n tr\u00ean c\u1ee7a d\u1ea3i:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Cong_thuc_2_Tao_ra_cac_so_ngau_nhien_giua_hai_so\" title=\"C\u00f4ng th\u1ee9c 2. T\u1ea1o ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa hai s\u1ed1:\">C\u00f4ng th\u1ee9c 2. T\u1ea1o ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa hai s\u1ed1:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Cong_thuc_3_Tao_cac_so_nguyen_ngau_nhien_trong_Excel\" title=\"C\u00f4ng th\u1ee9c 3. T\u1ea1o c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean trong Excel:\">C\u00f4ng th\u1ee9c 3. T\u1ea1o c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean trong Excel:<\/a><\/li>\n<\/ul>\n<\/li>\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\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Ham_RANDBETWEEN_%E2%80%93_tao_ra_so_ngau_nhien_trong_mot_pham_vi_quy_dinh\" title=\"H\u00e0m RANDBETWEEN \u00a0\u2013 t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean trong m\u1ed9t ph\u1ea1m vi quy \u0111\u1ecbnh\">H\u00e0m RANDBETWEEN \u00a0\u2013 t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean trong m\u1ed9t ph\u1ea1m vi quy \u0111\u1ecbnh<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Tao_so_ngau_nhien_voi_so_thap_phan_duoc_chi_dinh\" title=\"T\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean v\u1edbi s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh\">T\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean v\u1edbi s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Lam_the_nao_de_tao_ra_ngay_ngau_nhien_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o ra ng\u00e0y ng\u1eabu nhi\u00ean trong Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o ra ng\u00e0y ng\u1eabu nhi\u00ean trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Lam_the_nao_de_chen_thoi_gian_ngau_nhien_trong_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n th\u1eddi gian ng\u1eabu nhi\u00ean trong Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n th\u1eddi gian ng\u1eabu nhi\u00ean trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Cong_thuc_1_Tao_ngau_nhien_lan_trong_pham_vi_quy_dinh\" title=\"C\u00f4ng th\u1ee9c 1. T\u1ea1o ng\u1eabu nhi\u00ean l\u1ea7n trong ph\u1ea1m vi quy \u0111\u1ecbnh\">C\u00f4ng th\u1ee9c 1. T\u1ea1o ng\u1eabu nhi\u00ean l\u1ea7n trong ph\u1ea1m vi quy \u0111\u1ecbnh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Cong_thuc_2_Tao_ngay_va_thoi_gian_ngau_nhien\" title=\"C\u00f4ng th\u1ee9c 2. T\u1ea1o ng\u00e0y v\u00e0 th\u1eddi gian ng\u1eabu nhi\u00ean\">C\u00f4ng th\u1ee9c 2. T\u1ea1o ng\u00e0y v\u00e0 th\u1eddi gian ng\u1eabu nhi\u00ean<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Tao_cac_ky_tu_ngau_nhien_trong_Excel\" title=\"T\u1ea1o c\u00e1c k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean trong Excel\">T\u1ea1o c\u00e1c k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Tao_chuoi_van_ban_va_mat_khau_trong_Excel\" title=\"T\u1ea1o chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 m\u1eadt kh\u1ea9u trong Excel\">T\u1ea1o chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 m\u1eadt kh\u1ea9u trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.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<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/tao-ngay-thang-mat-khau-chuoi-van-ban-ngau-nhien-bang-ham-rand-va-randbetween.html#Tao_cac_so_ngau_nhien_doc_dao_trong_Excel\" title=\"T\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean \u0111\u1ed9c \u0111\u00e1o trong Excel\">T\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean \u0111\u1ed9c \u0111\u00e1o trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_RAND_%E2%80%93_tao_ra_so_ngau_nhien_thuc\"><\/span>H\u00e0m RAND \u2013 t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean th\u1ef1c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">H\u00e0m <strong>RAND<\/strong>\u00a0 trong Excel l\u00e0 m\u1ed9t trong hai h\u00e0m \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 t\u1ea1o ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean.\u00a0N\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n ng\u1eabu nhi\u00ean (s\u1ed1 th\u1ef1c) gi\u1eefa 0 v\u00e0 1.<\/p>\n<p style=\"text-align: justify\">RAND () l\u00e0 m\u1ed9t h\u00e0m b\u1ea5t \u0111\u1ecbnh, c\u00f3 ngh\u0129a l\u00e0 m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o ra m\u1ed7i khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n.\u00a0V\u00e0 \u0111i\u1ec1u n\u00e0y x\u1ea3y ra m\u1ed7i khi b\u1ea1n th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 h\u00e0nh \u0111\u1ed9ng n\u00e0o tr\u00ean b\u1ea3ng t\u00ednh, v\u00ed d\u1ee5 c\u1eadp nh\u1eadt c\u00f4ng th\u1ee9c (kh\u00f4ng nh\u1ea5t thi\u1ebft l\u00e0 c\u00f4ng th\u1ee9c RAND, ch\u1ec9 c\u1ea7n b\u1ea5t k\u1ef3 c\u00f4ng th\u1ee9c n\u00e0o kh\u00e1c tr\u00ean m\u1ed9t trang t\u00ednh), ch\u1ec9nh s\u1eeda m\u1ed9t \u00f4 ho\u1eb7c nh\u1eadp d\u1eef li\u1ec7u m\u1edbi.<\/p>\n<p style=\"text-align: justify\">H\u00e0m RAND c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel 2013, Excel 2010, 2007, 2003, XP v\u00e0 2000.<\/p>\n<p style=\"text-align: justify\">V\u00ec h\u00e0m RAND kh\u00f4ng c\u00f3 \u0111\u1ed1i s\u1ed1, b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp\u00a0<strong>=RAND() <\/strong>v\u00e0o \u00f4 v\u00e0 sao ch\u00e9p c\u00f4ng th\u1ee9c v\u00e0o nhi\u1ec1u \u00f4 n\u1ebfu b\u1ea1n mu\u1ed1n:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rand-function-excel.png\" alt=\"Generate random real numbers using Excel's RAND function\" title=\"rand-function-excel\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-296.gif\" title=\"vba101_92019-nho-296\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/ex101_92019-nho-665.gif\" title=\"ex101_92019-nho-665\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, ch\u00fang ta h\u00e3y \u0111i th\u00eam m\u1ed9t b\u01b0\u1edbc n\u1eefa v\u00e0 vi\u1ebft m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c RAND \u0111\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean theo c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee7a b\u1ea1n.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_1_Xac_dinh_gia_tri_gioi_han_tren_cua_dai\"><\/span>C\u00f4ng th\u1ee9c 1. X\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n tr\u00ean c\u1ee7a d\u1ea3i:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa s\u1ed1 kh\u00f4ng v\u00e0 b\u1ea5t k\u1ef3\u00a0gi\u00e1 tr\u1ecb\u00a0<em> N<\/em>\u00a0 n\u00e0o, b\u1ea1n c\u00f3 h\u00e0m RAND nh\u00e2n N:<\/p>\n<p style=\"text-align: justify\"><strong>= RAND () *\u00a0<em>N<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u1ea1o m\u1ed9t d\u00e3y s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0 nh\u01b0ng d\u01b0\u1edbi 50, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=RAND() * 50<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>Gi\u00e1 tr\u1ecb r\u00e0ng bu\u1ed9c ph\u00eda tr\u00ean kh\u00f4ng xu\u1ea5t hi\u1ec7n trong chu\u1ed7i ng\u1eabu nhi\u00ean tr\u1ea3 v\u1ec1.\u00a0V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n nh\u1eadn \u0111\u01b0\u1ee3c s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 0 \u0111\u1ebfn 10, bao g\u1ed3m 10, c\u00f4ng th\u1ee9c \u0111\u00fang l\u00e0\u00a0<strong>=RAND() * 11<\/strong>.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Tao_ra_cac_so_ngau_nhien_giua_hai_so\"><\/span>C\u00f4ng th\u1ee9c 2. T\u1ea1o ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa hai s\u1ed1:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa hai s\u1ed1 n\u00e0o m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c RAND sau:<\/p>\n<p style=\"text-align: justify\"><strong>= RAND () * (\u00a0<em>B<\/em>\u00a0\u2013\u00a0<em>A<\/em>\u00a0) +\u00a0<em>A<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Trong \u0111\u00f3\u00a0<em>A<\/em>\u00a0l\u00e0 gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n d\u01b0\u1edbi (s\u1ed1 nh\u1ecf nh\u1ea5t) v\u00e0\u00a0<em>B<\/em>\u00a0l\u00e0 gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n tr\u00ean (s\u1ed1 l\u1edbn nh\u1ea5t).<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa 10 v\u00e0 50, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=RAND() * (50-10) + 10<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>C\u00f4ng th\u1ee9c ng\u1eabu nhi\u00ean n\u00e0y s\u1ebd kh\u00f4ng tr\u1ea3 l\u1ea1i m\u1ed9t s\u1ed1 b\u1eb1ng s\u1ed1 l\u1edbn nh\u1ea5t c\u1ee7a d\u00e3y \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh (\u00a0gi\u00e1 tr\u1ecb\u00a0<em>B<\/em>\u00a0).<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_3_Tao_cac_so_nguyen_ngau_nhien_trong_Excel\"><\/span>C\u00f4ng th\u1ee9c 3. T\u1ea1o c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean trong Excel:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m cho h\u00e0m RAND t\u1ea1o ra c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean, l\u1ea5y m\u1ed9t trong hai c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u1ec1 c\u1eadp \u1edf tr\u00ean v\u00e0 nh\u00fang n\u00f3 trong h\u00e0m INT.<\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean gi\u1eefa 0 v\u00e0 50:<\/p>\n<p style=\"text-align: justify\"><strong>=INT(RAND()*50)<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean t\u1eeb 10 \u0111\u1ebfn 50:<\/p>\n<p style=\"text-align: justify\"><strong>=INT(RAND()*(50-10)+10)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/random-integers-excel.png\" alt=\"Generating random integers in Excel\" title=\"random-integers-excel\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ham_RANDBETWEEN_%E2%80%93_tao_ra_so_ngau_nhien_trong_mot_pham_vi_quy_dinh\"><\/span>H\u00e0m RANDBETWEEN \u00a0\u2013 t\u1ea1o ra s\u1ed1 ng\u1eabu nhi\u00ean trong m\u1ed9t ph\u1ea1m vi quy \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">RANDBETWEEN l\u00e0 m\u1ed9t h\u00e0m kh\u00e1c \u0111\u01b0\u1ee3c Excel t\u1ea1o ra \u0111\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean.\u00a0N\u00f3 tr\u1ea3 v\u1ec1\u00a0<strong>s\u1ed1 nguy\u00ean<\/strong>\u00a0ng\u1eabu nhi\u00ean\u00a0trong d\u00e3y m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh:<\/p>\n<p style=\"text-align: justify\"><strong>RANDBETWEEN (bottom<\/strong>\u00a0<strong>, top)<\/strong><\/p>\n<p style=\"text-align: justify\">R\u00f5 r\u00e0ng,\u00a0<strong>bottom<\/strong>\u00a0l\u00e0 s\u1ed1 th\u1ea5p nh\u1ea5t v\u00e0\u00a0<strong>top<\/strong>\u00a0l\u00e0 s\u1ed1 cao nh\u1ea5t trong ph\u1ea1m vi s\u1ed1 ng\u1eabu nhi\u00ean b\u1ea1n mu\u1ed1n nh\u1eadn \u0111\u01b0\u1ee3c.<\/p>\n<p style=\"text-align: justify\">Gi\u1ed1ng RAND, RANDBETWEEN c\u1ee7a l\u00e0 m\u1ed9t h\u00e0m kh\u00f4ng b\u1ea5t \u0111\u1ecbnh v\u00e0 n\u00f3 tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean m\u1edbi m\u1ed7i khi b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n l\u1ea1i.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean gi\u1eefa 10 v\u00e0 50 (k\u1ec3 c\u1ea3 10 v\u00e0 50), s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c RANDBETWEEN sau:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(10, 50)<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/randbetween-function-excel.png\" alt=\"Using the RANDBETWEEN function to generate random integers in a specified range\" title=\"randbetween-function-excel\"><\/p>\n<p style=\"text-align: justify\">H\u00e0m RANDBETWEEN trong Excel c\u00f3 th\u1ec3 t\u1ea1o ra c\u1ea3 hai s\u1ed1 d\u01b0\u01a1ng v\u00e0 \u00e2m.\u00a0V\u00ed d\u1ee5, \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean t\u1eeb -10 \u0111\u1ebfn 10, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(-10, 10)<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/tag\/ham-randbetween\">H\u00e0m RANDBETWEEN<\/a> hi\u1ec7n c\u00f3 trong c\u00e1c phi\u00ean b\u1ea3n Excel 2016, Excel 2013, Excel 2010 v\u00e0 Excel 2007. Trong c\u00e1c phi\u00ean b\u1ea3n c\u0169, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c RAND th\u1ec3 hi\u1ec7n trong\u00a0v\u00ed d\u1ee5 3\u00a0\u1edf tr\u00ean.<\/p>\n<p style=\"text-align: justify\">Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t v\u00e0i c\u00f4ng th\u1ee9c minh ho\u1ea1 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m RANDBETWEEN \u0111\u1ec3 t\u1ea1o c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean kh\u00e1c v\u1edbi s\u1ed1 nguy\u00ean.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_so_ngau_nhien_voi_so_thap_phan_duoc_chi_dinh\"><\/span>T\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean v\u1edbi s\u1ed1 th\u1eadp ph\u00e2n \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1eb7c d\u00f9 h\u00e0m RANDBEETWEEN trong Excel \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 b\u1eaft bu\u1ed9c n\u00f3 ph\u1ea3i tr\u1ea3 l\u1ea1i c\u00e1c s\u1ed1 th\u1eadp ph\u00e2n ng\u1eabu nhi\u00ean v\u1edbi nhi\u1ec1u \u0111\u1ed9 d\u00e0i th\u1eadp ph\u00e2n nh\u01b0 b\u1ea1n mu\u1ed1n.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5, \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch c\u00e1c s\u1ed1 v\u1edbi m\u1ed9t v\u1ecb tr\u00ed th\u1eadp ph\u00e2n, b\u1ea1n nh\u00e2n c\u00e1c gi\u00e1 tr\u1ecb d\u01b0\u1edbi v\u00e0 \u0111\u1ea7u trang cho 10, v\u00e0 sau \u0111\u00f3 chia gi\u00e1 tr\u1ecb tr\u1ea3 v\u1ec1 cho 10:<\/p>\n<p style=\"text-align: justify\"><strong>= RANDBETWEEN (\u00a0<em>bottom value <\/em>* 10,\u00a0<em>top value <\/em>* 10) \/ 10<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c RANDBETWEEN sau \u0111\u00e2y tr\u1ea3 v\u1ec1 s\u1ed1 th\u1eadp ph\u00e2n ng\u1eabu nhi\u00ean gi\u1eefa 1 v\u00e0 50:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(1*10, 50*10) \/ 10<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/generate-random-decimals-excel.png\" alt=\"Create random numbers with as many decimal places as you want\" title=\"generate-random-decimals-excel\"><\/p>\n<p style=\"text-align: justify\">Theo c\u00e1ch t\u01b0\u01a1ng t\u1ef1, \u0111\u1ec3 t\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa 1 v\u00e0 50 v\u1edbi 2 s\u1ed1 th\u1eadp ph\u00e2n, b\u1ea1n nh\u00e2n c\u00e1c \u0111\u1ed1i s\u1ed1 c\u1ee7a h\u00e0m RANDBETWEEN cho 100, v\u00e0 sau \u0111\u00f3 chia k\u1ebft qu\u1ea3 cho 100:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(1*100, 50*100) \/ 100<\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tao_ra_ngay_ngau_nhien_trong_Excel\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o ra ng\u00e0y ng\u1eabu nhi\u00ean trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t danh s\u00e1ch c\u00e1c ng\u00e0y ng\u1eabu nhi\u00ean gi\u1eefa hai ng\u00e0y, s\u1eed d\u1ee5ng h\u00e0m RANDBETWEEN k\u1ebft h\u1ee3p v\u1edbi\u00a0DATEVALUE\u00a0:<\/p>\n<p style=\"text-align: justify\"><strong>= RANDBETWEEN (DATEVALUE (\u00a0<em>ng\u00e0y b\u1eaft \u0111\u1ea7u<\/em>\u00a0), DATEVALUE (\u00a0<em>ng\u00e0y k\u1ebft th\u00fac<\/em>\u00a0))<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c danh s\u00e1ch c\u00e1c ng\u00e0y gi\u1eefa ng\u00e0y 1 th\u00e1ng 6 n\u0103m 2015 v\u00e0 ng\u00e0y 30 th\u00e1ng 6 n\u0103m 2015, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau trong b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(DATEVALUE(\u201c1-Jun-2015\u201d), DATEVALUE(\u201c30-Jun-2015\u201d))<\/strong><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u00f9ng h\u00e0m\u00a0DATE\u00a0thay v\u00ec DATEVALUE:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(DATE(2015,6,1), DATEVALUE(2015,6,30))<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb \u00e1p d\u1ee5ng\u00a0\u0111\u1ecbnh d\u1ea1ng ng\u00e0y\u00a0cho (c\u00e1c) \u00f4 v\u00e0 b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t danh s\u00e1ch c\u00e1c ng\u00e0y ng\u1eabu nhi\u00ean t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-random-dates.png\" alt=\"Generating random dates in Excel\" title=\"excel-random-dates\"><\/p>\n<p style=\"text-align: justify\"><strong>Xem th\u00eam<\/strong>:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-dien-ngay-thang-vao-excel-thong-tin-ngay-thang-hien-tai-tu-dong-dien-ngay-thang-vao-cot.html#Cach_dien_ngay_thang_mot_cach_ngau_nhien_trong_Excel\">C\u00e1ch \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o Excel, th\u00eam th\u00f4ng tin ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i, t\u1ef1 \u0111\u1ed9ng \u0111i\u1ec1n ng\u00e0y th\u00e1ng v\u00e0o c\u1ed9t<\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_chen_thoi_gian_ngau_nhien_trong_Excel\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00e8n th\u1eddi gian ng\u1eabu nhi\u00ean trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u1edb r\u1eb1ng trong kho\u1ea3ng th\u1eddi gian c\u1ee7a Excel \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng th\u1eadp ph\u00e2n, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m RAND chu\u1ea9n \u0111\u1ec3 ch\u00e8n c\u00e1c s\u1ed1 th\u1ef1c ng\u1eabu nhi\u00ean v\u00e0 sau \u0111\u00f3 ch\u1ec9 c\u1ea7n\u00a0\u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian\u00a0v\u00e0o c\u00e1c \u00f4:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/img-blog\/inserting-excel-random-times.png\" alt=\"Insert random times by using the standard RAND function and applying the time format\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1ea3 l\u1ea1i th\u1eddi gian ng\u1eabu nhi\u00ean theo ti\u00eau ch\u00ed c\u1ee7a b\u1ea1n, c\u1ea7n c\u00e1c c\u00f4ng th\u1ee9c ng\u1eabu nhi\u00ean c\u1ee5 th\u1ec3 h\u01a1n, nh\u01b0 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_1_Tao_ngau_nhien_lan_trong_pham_vi_quy_dinh\"><\/span>C\u00f4ng th\u1ee9c 1. T\u1ea1o ng\u1eabu nhi\u00ean l\u1ea7n trong ph\u1ea1m vi quy \u0111\u1ecbnh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u00e8n ng\u1eabu nhi\u00ean th\u1eddi gian gi\u1eefa b\u1ea5t k\u1ef3 hai th\u1eddi gian m\u00e0 b\u1ea1n ch\u1ec9 \u0111\u1ecbnh, s\u1eed d\u1ee5ng h\u00e0m TIME\u00a0ho\u1eb7c TIMEVALUE k\u1ebft h\u1ee3p v\u1edbi RAND:<\/p>\n<p style=\"text-align: justify\"><strong>= TIME (\u00a0<em>th\u1eddi gian b\u1eaft \u0111\u1ea7u<\/em>\u00a0) + RAND () * (TIME (\u00a0<em>th\u1eddi gian b\u1eaft \u0111\u1ea7u<\/em>\u00a0) \u2013 TIME (\u00a0<em>th\u1eddi gian k\u1ebft th\u00fac<\/em>\u00a0))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>= TIMEVALUE (\u00a0<em>th\u1eddi gian b\u1eaft \u0111\u1ea7u<\/em>\u00a0) + RAND () * (TIMEVALUE (\u00a0<em>th\u1eddi gian b\u1eaft \u0111\u1ea7u<\/em>\u00a0) \u2013 TIMEVALUE (\u00a0<em>th\u1eddi gian k\u1ebft th\u00fac<\/em>\u00a0))<\/strong><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ec3 ch\u00e8n th\u1eddi gian ng\u1eabu nhi\u00ean gi\u1eefa 6 gi\u1edd s\u00e1ng \u0111\u1ebfn 5 gi\u1edd 30 t\u1ed1i, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng m\u1ed9t trong hai c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=TIME(6,0,0) + RAND() * (TIME(17,30,0) \u2013 TIME(6,0,0))<\/strong><\/p>\n<p style=\"text-align: justify\"><strong>=TIMEVALUE(\u201c6:00 AM\u201d) + RAND() * (TIMEVALUE(\u201c5:30 PM\u201d) \u2013 TIMEVALUE(\u201c6:00 AM\u201d))<\/strong><br \/>\n<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-random-times.png\" alt=\"The TIME \/ RAND formula to generate random times in Excel\" title=\"excel-random-times\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_thuc_2_Tao_ngay_va_thoi_gian_ngau_nhien\"><\/span>C\u00f4ng th\u1ee9c 2. T\u1ea1o ng\u00e0y v\u00e0 th\u1eddi gian ng\u1eabu nhi\u00ean<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t danh s\u00e1ch c\u00e1c\u00a0<strong>ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian<\/strong>\u00a0ng\u1eabu nhi\u00ean\u00a0, h\u00e3y s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00e1c h\u00e0m RANDBETWEEN v\u00e0 DATEVALUE:<\/p>\n<p style=\"text-align: justify\"><strong>= RANDBETWEEN (DATEVALUE (\u00a0<em>ng\u00e0y b\u1eaft \u0111\u1ea7u)<\/em>\u00a0, DATEVALUE (\u00a0<em>ng\u00e0y k\u1ebft th\u00fac<\/em>\u00a0)) + RANDBETWEEN (TIMEVALUE (\u00a0<em>th\u1eddi gian b\u1eaft \u0111\u1ea7u<\/em>\u00a0) * 10000, TIMEVALUE (\u00a0<em>th\u1eddi gian k\u1ebft th\u00fac<\/em>\u00a0) * 10000) \/ 10000<\/strong><\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n mu\u1ed1n ch\u00e8n c\u00e1c ng\u00e0y ng\u1eabu nhi\u00ean t\u1eeb ng\u00e0y 1 th\u00e1ng 6 n\u0103m 2015 \u0111\u1ebfn ng\u00e0y 30 th\u00e1ng 6 n\u0103m 2015 v\u1edbi th\u1eddi gian t\u1eeb 7 gi\u1edd 30 s\u00e1ng \u0111\u1ebfn 6 gi\u1edd chi\u1ec1u, ta c\u00f3 c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(DATEVALUE(\u201c1-Jun-2015\u201d), DATEVALUE(\u201c30-Jun-2015\u201d)) + RANDBETWEEN(TIMEVALUE(\u201c7:30 AM\u201d) * 10000, TIMEVALUE(\u201c6:00 PM\u201d) * 10000) \/ 10000<\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-random-dates-times.png\" alt=\"Generating random dates and times in a specified range\" title=\"excel-random-dates-times\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 thay th\u1eddi gian v\u00e0 ng\u00e0y s\u1eed d\u1ee5ng v\u1edbi h\u00e0m DATE v\u00e0 TIME, t\u01b0\u01a1ng \u1ee9ng:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(DATE(2015,6,1), DATE(2015,6,30)) + RANDBETWEEN(TIME(7,30,0) * 10000, TIME(18,0,0) * 10000) \/ 10000<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_cac_ky_tu_ngau_nhien_trong_Excel\"><\/span>T\u1ea1o c\u00e1c k\u00fd t\u1ef1 ng\u1eabu nhi\u00ean trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t ch\u1eef c\u00e1i ng\u1eabu nhi\u00ean, c\u1ea7u m\u1ed9t s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a ba h\u00e0m kh\u00e1c nhau:<\/p>\n<p style=\"text-align: justify\"><strong>=CHAR(RANDBETWEEN(CODE(\u201cA\u201d), CODE(\u201cZ\u201d)))<\/strong><\/p>\n<p style=\"text-align: justify\">V\u1edbi \u00a0<em>A<\/em>\u00a0l\u00e0 k\u00fd t\u1ef1 \u0111\u1ea7u ti\u00ean v\u00e0\u00a0<em>Z<\/em>\u00a0l\u00e0 k\u00fd t\u1ef1 cu\u1ed1i c\u00f9ng trong d\u00e3y ch\u1eef c\u00e1i b\u1ea1n mu\u1ed1n (theo th\u1ee9 t\u1ef1 ch\u1eef c\u00e1i).<\/p>\n<p style=\"text-align: justify\">Trong c\u00f4ng th\u1ee9c tr\u00ean:<\/p>\n<ul style=\"text-align: justify\">\n<li>CODE tr\u1ea3 v\u1ec1 c\u00e1c m\u00e3 ANSI s\u1ed1 cho c\u00e1c ch\u1eef c\u00e1i \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/li>\n<li>RANDBETWEEN l\u1ea5y c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c tr\u1ea3 v\u1ec1 b\u1edfi c\u00e1c h\u00e0m CODE d\u01b0\u1edbi d\u1ea1ng c\u00e1c gi\u00e1 tr\u1ecb tr\u00ean v\u00e0 d\u01b0\u1edbi c\u00f9ng c\u1ee7a d\u00e3y.<\/li>\n<li>CHAR chuy\u1ec3n \u0111\u1ed5i c\u00e1c m\u00e3 ANSI ng\u1eabu nhi\u00ean \u0111\u01b0\u1ee3c RANDBETWEEN tr\u1ea3 l\u1ea1i cho c\u00e1c ch\u1eef c\u00e1i t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/random-letters-excel.png\" alt=\"Generating random letters in Excel\" title=\"random-letters-excel\"><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.\u00a0<\/strong>V\u00ec c\u00e1c m\u00e3 ANSI ph\u00e2n bi\u1ec7t ch\u1eef hoa v\u00e0 ch\u1eef th\u01b0\u1eddng, c\u00f4ng th\u1ee9c n\u00e0y l\u00e0\u00a0<strong>ch\u1eef hoa<\/strong>\u00a0.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n nh\u1edb\u00a0 m\u00e3 k\u00fd t\u1ef1 ANSI\u00a0trong \u0111\u1ea7u, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 ghi tr\u1ef1c ti\u1ebfp trong h\u00e0m RANDBETWEEN.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u1ea1o ch\u1eef Hoa\u00a0ng\u1eabu nhi\u00ean\u00a0gi\u1eefa\u00a0<em>A<\/em>\u00a0(ANSI code 65) v\u00e0\u00a0<em>Z<\/em>\u00a0(ANSI code 90), b\u1ea1n vi\u1ebft:<\/p>\n<p style=\"text-align: justify\"><strong>=CHAR(RANDBETWEEN(65, 90))<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o c\u00e1c\u00a0<strong>ch\u1eef th\u01b0\u1eddng<\/strong>\u00a0t\u1eeb\u00a0<em>a<\/em>\u00a0(ANSI code 97) \u0111\u1ebfn\u00a0<em>z<\/em>\u00a0(m\u00e3 ANSI 122), b\u1ea1n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p style=\"text-align: justify\"><strong>=CHAR(RANDBETWEEN(97, 122))<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 ch\u00e8n m\u1ed9t k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ng\u1eabu nhi\u00ean, ch\u1eb3ng h\u1ea1n nh\u01b0\u00a0<em>!\u00a0\u201c# $% &amp; \u2018() * +, -. \/,<\/em>\u00a0S\u1eed d\u1ee5ng h\u00e0m RANDBETWEEN v\u1edbi tham s\u1ed1\u00a0<strong>d\u01b0\u1edbi c\u00f9ng<\/strong>\u00a0l\u00e0 33 (m\u00e3 ANSI cho\u201d! \u201c) V\u00e0 tham s\u1ed1\u00a0<strong>\u0111\u1ea7u<\/strong>\u00a0\u0111\u1eb7t l\u00e0 47 (m\u00e3 ANSI cho\u201d \/ \u201c).<\/p>\n<p style=\"text-align: justify\"><strong>=CHAR(RANDBETWEEN(33,47))<\/strong><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_chuoi_van_ban_va_mat_khau_trong_Excel\"><\/span>T\u1ea1o chu\u1ed7i v\u0103n b\u1ea3n v\u00e0 m\u1eadt kh\u1ea9u trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea1o m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n ng\u1eabu nhi\u00ean trong Excel, b\u1ea1n ch\u1ec9 c\u1ea7n n\u1ed1i m\u1ed9t v\u00e0i h\u00e0m CHAR \/ RANDBEETWEEN.<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5: \u0111\u1ec3 t\u1ea1o danh s\u00e1ch m\u1eadt kh\u1ea9u g\u1ed3m 4 k\u00fd t\u1ef1, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>=RANDBETWEEN(0,9) &amp; CHAR(RANDBETWEEN(65,90)) &amp; CHAR(RANDBETWEEN(97, 122)) &amp; CHAR(RANDBETWEEN(33,47))<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u00e0m cho c\u00f4ng th\u1ee9c th\u00eam g\u1ecdn nh\u1eb9, t\u00f4i cung c\u1ea5p c\u00e1c m\u00e3 ANSI tr\u1ef1c ti\u1ebfp trong c\u00f4ng th\u1ee9c.\u00a0B\u1ed1n h\u00e0m tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean sau:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>RANDBETWEEN(0,9)<\/strong>\u00a0\u2013 tr\u1ea3 v\u1ec1 s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 0 \u0111\u1ebfn 9.<\/li>\n<li><strong>CHAR(RANDBETWEEN(65,90))<\/strong>\u2013 tr\u1ea3 v\u1ec1 ch\u1eef hoa ng\u1eabu nhi\u00ean gi\u1eefa\u00a0<em>A<\/em>\u00a0v\u00e0\u00a0<em>Z<\/em>\u00a0.<\/li>\n<li><strong>CHAR(RANDBETWEEN(97, 122))<\/strong>\u2013 Tr\u1ea3 v\u1ec1 c\u00e1c k\u00fd t\u1ef1 ch\u1eef th\u01b0\u1eddng ng\u1eabu nhi\u00ean gi\u1eefa\u00a0<em>a<\/em>\u00a0v\u00e0\u00a0<em>z<\/em>\u00a0.<\/li>\n<li><strong>CHAR(RANDBETWEEN(33,47))<\/strong>\u00a0\u2013 Tr\u1ea3 v\u1ec1 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t ng\u1eabu nhi\u00ean.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">C\u00e1c chu\u1ed7i v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1eb1ng c\u00f4ng th\u1ee9c tr\u00ean s\u1ebd l\u00e0 m\u1ed9t c\u00e1i g\u00ec \u0111\u00f3 nh\u01b0 \u201d\u00a0<em>4Np #<\/em>\u00a0\u201d ho\u1eb7c \u201d\u00a0<em>2Yu &amp;<\/em>\u00a0\u201c.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-random-passwords.png\" alt=\"Generating text strings in Excel\" title=\"excel-random-passwords\"><\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1nh b\u00e1o!\u00a0<\/strong>N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng m\u1ed9t c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 t\u1ea1o m\u1eadt kh\u1ea9u ng\u1eabu nhi\u00ean, ch\u00fang s\u1ebd kh\u00f4ng m\u1ea1nh.\u00a0T\u1ea5t nhi\u00ean, t\u00f4i kh\u00f4ng n\u00f3i r\u1eb1ng b\u1ea1n kh\u00f4ng th\u1ec3 t\u1ea1o ra c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n d\u00e0i h\u01a1n b\u1eb1ng c\u00e1ch n\u1ed1i th\u00eam c\u00e1c h\u00e0m CHAR \/ RANDBETWEEN.\u00a0Nh\u01b0ng, kh\u00f4ng th\u1ec3 ng\u1eabu nhi\u00ean ho\u00e1 th\u1ee9 t\u1ef1 ho\u1eb7c c\u00e1c k\u00fd t\u1ef1, t\u1ee9c l\u00e0 h\u00e0m \u0111\u1ea7u ti\u00ean\u00a0lu\u00f4n tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1,\u00a0h\u00e0m th\u1ee9\u00a0tr\u1ea3 v\u1ec1 ch\u1eef hoa,\u2026<\/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<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_cac_so_ngau_nhien_doc_dao_trong_Excel\"><\/span>T\u1ea1o c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean \u0111\u1ed9c \u0111\u00e1o trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Kh\u00f4ng nh\u1eefng h\u00e0m ng\u1eabu nhi\u00ean c\u1ee7a Excel c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean \u0111\u1ed9c \u0111\u00e1o.\u00a0M\u00e0 n\u1ebfu ai \u0111\u00f3 \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t b\u1ed9 ph\u00e1t s\u1ed1 ng\u1eabu nhi\u00ean duy nh\u1ea5t trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1ch t sau \u0111\u00e2y.<\/p>\n<ol>\n<li style=\"text-align: justify\">S\u1eed d\u1ee5ng h\u00e0m RAND ho\u1eb7c RANDBETWEEN \u0111\u1ec3 t\u1ea1o ra m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean.\u00a0T\u1ea1o ra nhi\u1ec1u gi\u00e1 tr\u1ecb h\u01a1n b\u1ea1n th\u1ef1c s\u1ef1 c\u1ea7n v\u00ec m\u1ed9t s\u1ed1 b\u1ea3n sao s\u00e9 \u0111\u01b0\u1ee3c x\u00f3a sau.<\/li>\n<li style=\"text-align: justify\">Chuy\u1ec3n \u0111\u1ed5i c\u00f4ng th\u1ee9c th\u00e0nh c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 \u0111\u01b0\u1ee3c gi\u1ea3i th\u00edch trong\u00a0L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ng\u0103n h\u00e0m ng\u1eabu nhi\u00ean c\u1ee7a Excel t\u00ednh l\u1ea1i\u00a0.<\/li>\n<li style=\"text-align: justify\">Lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c sao ch\u00e9p b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Duplicate Remover t\u00edch h\u1ee3p trong Excel (\u00a0Tab\u00a0<em>Data\u00a0 <\/em>&gt;\u00a0<em>Remove Duplicates<\/em>).<\/li>\n<\/ol>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c m\u00e0 ch\u00fang ta ch\u01b0a bi\u1ebft ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/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\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-296.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7405","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7405","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=7405"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7405\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7406"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}