{"id":501751,"date":"2025-10-29T15:16:11","date_gmt":"2025-10-29T08:16:11","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=501751"},"modified":"2025-10-29T15:16:11","modified_gmt":"2025-10-29T08:16:11","slug":"ham-random-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-random-trong-excel\/","title":{"rendered":"H\u00e0m Random trong Excel l\u00e0 g\u00ec? C\u00e1ch s\u1eed d\u1ee5ng k\u00e8m v\u00ed d\u1ee5 minh h\u1ecda c\u1ee5 th\u1ec3"},"content":{"rendered":"

H\u00e0m Random trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 m\u1ea1nh m\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng t\u1ea1o ra c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean, th\u01b0\u1eddng \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong th\u1ed1ng k\u00ea, m\u00f4 ph\u1ecfng d\u1eef li\u1ec7u, ho\u1eb7c ki\u1ec3m th\u1eed m\u00f4 h\u00ecnh. V\u1edbi kh\u1ea3 n\u0103ng sinh ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng nh\u1ea5t \u0111\u1ecbnh, h\u00e0m n\u00e0y gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng \u0111\u1ed9 linh ho\u1ea1t khi l\u00e0m vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh. Vi\u1ec7c hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Random kh\u00f4ng ch\u1ec9 gi\u00fap b\u1ea1n thao t\u00e1c nhanh h\u01a1n m\u00e0 c\u00f2n m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng x\u1eed l\u00fd d\u1eef li\u1ec7u chuy\u00ean nghi\u1ec7p h\u01a1n trong c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng, nghi\u00ean c\u1ee9u hay ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u.<\/span><\/p>\n

H\u00e0m Random trong Excel l\u00e0 g\u00ec?<\/span><\/h2>\n

H\u00e0m Random l\u00e0 nh\u00f3m h\u00e0m d\u00f9ng \u0111\u1ec3 t\u1ea1o ra c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 th\u1ef1c ho\u1eb7c s\u1ed1 nguy\u00ean t\u00f9y theo nhu c\u1ea7u. \u0110\u00e2y l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 hi\u1ec7u qu\u1ea3 trong vi\u1ec7c sinh d\u1eef li\u1ec7u m\u1eabu, th\u1eed nghi\u1ec7m c\u00f4ng th\u1ee9c, ho\u1eb7c m\u00f4 ph\u1ecfng c\u00e1c t\u00ecnh hu\u1ed1ng ng\u1eabu nhi\u00ean trong t\u00ednh to\u00e1n.<\/span><\/p>\n

Ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m Random<\/span><\/h3>\n

Ch\u1ee9c n\u0103ng ch\u00ednh c\u1ee7a h\u00e0m Random trong Excel l\u00e0 t\u1ea1o ra c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean nh\u1eb1m ph\u1ee5c v\u1ee5 nhi\u1ec1u m\u1ee5c \u0111\u00edch kh\u00e1c nhau. Khi b\u1ea1n c\u1ea7n m\u1ed9t t\u1eadp d\u1eef li\u1ec7u th\u1eed nghi\u1ec7m m\u00e0 kh\u00f4ng mu\u1ed1n nh\u1eadp th\u1ee7 c\u00f4ng, h\u00e0m n\u00e0y s\u1ebd gi\u00fap sinh ra c\u00e1c gi\u00e1 tr\u1ecb t\u1ef1 \u0111\u1ed9ng v\u00e0 linh ho\u1ea1t.<\/span><\/p>\n

C\u1ee5 th\u1ec3, h\u00e0m RAND() t\u1ea1o ra s\u1ed1 th\u1ef1c ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 0 \u0111\u1ebfn nh\u1ecf h\u01a1n 1, trong khi RANDBETWEEN() l\u1ea1i cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng ch\u1ec9 \u0111\u1ecbnh gi\u1edbi h\u1ea1n c\u1ee5 th\u1ec3 \u2013 v\u00ed d\u1ee5 t\u1eeb 1 \u0111\u1ebfn 100. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n d\u1ec5 d\u00e0ng t\u00f9y ch\u1ec9nh d\u1eef li\u1ec7u theo nhu c\u1ea7u th\u1ef1c t\u1ebf.<\/span><\/p>\n

\"ham-random-trong-excel-2\"<\/picture><\/p>\n

Ngo\u00e0i ra, h\u00e0m Random c\u00f2n \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng trong vi\u1ec7c m\u00f4 ph\u1ecfng x\u00e1c su\u1ea5t, ch\u1ecdn ng\u1eabu nhi\u00ean \u0111\u1ed1i t\u01b0\u1ee3ng, chia nh\u00f3m ng\u1eabu nhi\u00ean ho\u1eb7c t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u th\u1eed nghi\u1ec7m cho c\u00e1c m\u00f4 h\u00ecnh th\u1ed1ng k\u00ea. M\u1ed7i l\u1ea7n b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n l\u1ea1i (nh\u1ea5n F9), gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean s\u1ebd thay \u0111\u1ed5i, mang l\u1ea1i k\u1ebft qu\u1ea3 m\u1edbi m\u1ed7i l\u1ea7n s\u1eed d\u1ee5ng.<\/span><\/p>\n

C\u00e1c lo\u1ea1i h\u00e0m Random trong Excel<\/span><\/h3>\n

Excel cung c\u1ea5p hai lo\u1ea1i h\u00e0m Random ph\u1ed5 bi\u1ebfn l\u00e0 RAND() v\u00e0 RANDBETWEEN(), m\u1ed7i lo\u1ea1i ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c \u0111\u00edch kh\u00e1c nhau.<\/span><\/p>\n

H\u00e0m RAND(): D\u1ea1ng c\u00fa ph\u00e1p l\u00e0 =RAND(), kh\u00f4ng c\u00f3 \u0111\u1ed1i s\u1ed1. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 m\u1ed9t s\u1ed1 th\u1eadp ph\u00e2n ng\u1eabu nhi\u00ean t\u1eeb 0 \u0111\u1ebfn nh\u1ecf h\u01a1n 1, v\u00ed d\u1ee5 0.4275. \u0110\u1ec3 l\u1ea5y s\u1ed1 trong ph\u1ea1m vi kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 nh\u00e2n v\u00e0 c\u1ed9ng th\u00eam gi\u00e1 tr\u1ecb mong mu\u1ed1n, ch\u1eb3ng h\u1ea1n =RAND()*100 \u0111\u1ec3 t\u1ea1o s\u1ed1 t\u1eeb 0\u2013100.<\/span><\/p>\n

\"ham-random-trong-excel-3\"<\/picture><\/p>\n

H\u00e0m RANDBETWEEN(): D\u1ea1ng c\u00fa ph\u00e1p l\u00e0 =RANDBETWEEN(bottom, top), trong \u0111\u00f3 bottom v\u00e0 top l\u00e0 hai gi\u1edbi h\u1ea1n d\u01b0\u1edbi v\u00e0 tr\u00ean. V\u00ed d\u1ee5 =RANDBETWEEN(1, 50) s\u1ebd t\u1ea1o ra s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean t\u1eeb 1 \u0111\u1ebfn 50.<\/span><\/p>\n

Ngo\u00e0i ra, Excel 365 c\u00f2n h\u1ed7 tr\u1ee3 RANDARRAY(), gi\u00fap t\u1ea1o m\u1ea3ng nhi\u1ec1u s\u1ed1 ng\u1eabu nhi\u00ean c\u00f9ng l\u00fac, r\u1ea5t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u l\u1edbn ho\u1eb7c m\u00f4 ph\u1ecfng x\u00e1c su\u1ea5t nhi\u1ec1u chi\u1ec1u. Nh\u1edd \u0111\u00f3, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 linh ho\u1ea1t t\u1ea1o b\u1ed9 d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean ph\u1ee5c v\u1ee5 h\u1ecdc t\u1eadp, nghi\u00ean c\u1ee9u hay b\u00e1o c\u00e1o th\u1ed1ng k\u00ea nhanh ch\u00f3ng v\u00e0 ti\u1ec7n l\u1ee3i.<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Random trong Excel \u0111\u1ec3 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean<\/span><\/h2>\n

H\u00e0m Random c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u1ee9ng d\u1ee5ng linh ho\u1ea1t \u0111\u1ec3 sinh ra c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean ph\u1ee5c v\u1ee5 cho vi\u1ec7c m\u00f4 ph\u1ecfng d\u1eef li\u1ec7u, th\u1ed1ng k\u00ea ho\u1eb7c th\u1eed nghi\u1ec7m m\u00f4 h\u00ecnh. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Random \u0111\u1ec3 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean v\u1edbi t\u1eebng tr\u01b0\u1eddng h\u1ee3p c\u1ee5 th\u1ec3, d\u1ec5 hi\u1ec3u v\u00e0 chi ti\u1ebft.<\/span><\/p>\n

S\u1ed1 ng\u1eabu nhi\u00ean n\u1eb1m trong kho\u1ea3ng [0, 1]<\/span><\/h3>\n

\u0110\u1ec3 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 0 v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 1, b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c:\u00a0<\/span><\/p>\n

=RAND()<\/span><\/p>\n

\"ham-random-trong-excel-4\"<\/picture><\/p>\n

H\u00e0m n\u00e0y kh\u00f4ng c\u1ea7n b\u1ea5t k\u1ef3 \u0111\u1ed1i s\u1ed1 n\u00e0o. M\u1ed7i khi nh\u1eadp c\u00f4ng th\u1ee9c v\u00e0o m\u1ed9t \u00f4 trong Excel, h\u00e0m RAND() s\u1ebd t\u1ef1 \u0111\u1ed9ng sinh ra m\u1ed9t s\u1ed1 th\u1ef1c ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 0 \u2264 x < 1. V\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 0.3275, 0.9812 ho\u1eb7c 0.0456, t\u00f9y m\u1ed7i l\u1ea7n t\u00ednh to\u00e1n.<\/span><\/p>\n

\u0110i\u1ec3m \u0111\u1eb7c bi\u1ec7t l\u00e0 gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean n\u00e0y s\u1ebd thay \u0111\u1ed5i m\u1ed7i khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c l\u00e0m m\u1edbi (\u1ea5n F9 ho\u1eb7c th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh kh\u00e1c). N\u1ebfu b\u1ea1n mu\u1ed1n \u201cc\u1ed1 \u0111\u1ecbnh\u201d gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean \u0111\u00e3 t\u1ea1o, h\u00e3y sao ch\u00e9p \u00f4 \u0111\u00f3 v\u00e0 d\u00e1n d\u01b0\u1edbi d\u1ea1ng Gi\u00e1 tr\u1ecb (Value). H\u00e0m RAND() r\u1ea5t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n t\u1ea1o d\u1eef li\u1ec7u th\u1eed nghi\u1ec7m, m\u00f4 ph\u1ecfng x\u00e1c su\u1ea5t ho\u1eb7c l\u1ef1a ch\u1ecdn ng\u1eabu nhi\u00ean trong c\u00e1c b\u00e0i to\u00e1n th\u1ed1ng k\u00ea v\u00e0 ph\u00e2n t\u00edch.<\/span><\/p>\n

S\u1ed1 ng\u1eabu nhi\u00ean n\u1eb1m trong kho\u1ea3ng [a, b]<\/span><\/h3>\n

\u0110\u1ec3 t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng a v\u00e0 nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng b, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Random trong Excel nh\u01b0 sau:\u00a0<\/span><\/p>\n

=RAND()*(b – a) + a<\/span><\/p>\n

\"ham-random-trong-excel-5\"<\/picture><\/p>\n

Trong \u0111\u00f3, a l\u00e0 gi\u1edbi h\u1ea1n d\u01b0\u1edbi v\u00e0 b l\u00e0 gi\u1edbi h\u1ea1n tr\u00ean c\u1ee7a kho\u1ea3ng b\u1ea1n mu\u1ed1n t\u1ea1o. V\u00ed d\u1ee5, n\u1ebfu c\u1ea7n sinh ra s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 100, ta \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c:\u00a0<\/span><\/p>\n

=RAND()*(100 – 1) + 1<\/span><\/p>\n

Khi \u0111\u00f3, Excel s\u1ebd tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 th\u1ef1c ng\u1eabu nhi\u00ean n\u1eb1m trong kho\u1ea3ng 1 \u2264 x < 100, ch\u1eb3ng h\u1ea1n 23.4756 ho\u1eb7c 78.9201.<\/span><\/p>\n

N\u1ebfu mu\u1ed1n l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb th\u00e0nh s\u1ed1 nguy\u00ean, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p th\u00eam h\u00e0m ROUND(), v\u00ed d\u1ee5:<\/span><\/p>\n

=ROUND(RAND()*(100 – 1) + 1, 0)<\/span><\/p>\n

H\u00e0m n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch trong vi\u1ec7c t\u1ea1o d\u1eef li\u1ec7u ng\u1eabu nhi\u00ean theo gi\u1edbi h\u1ea1n mong mu\u1ed1n, m\u00f4 ph\u1ecfng t\u00ecnh hu\u1ed1ng x\u00e1c su\u1ea5t, ho\u1eb7c t\u1ea1o danh s\u00e1ch \u0111i\u1ec3m s\u1ed1, gi\u00e1 tr\u1ecb th\u1eed nghi\u1ec7m trong Excel.\u00a0<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn random s\u1ed1 nguy\u00ean trong kho\u1ea3ng v\u1edbi h\u00e0m RANDBETWEEN<\/span><\/h2>\n

H\u00e0m RANDBETWEEN l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m t\u1ea1o s\u1ed1 ng\u1eabu nhi\u00ean ph\u1ed5 bi\u1ebfn trong Excel, gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng sinh ra c\u00e1c s\u1ed1 nguy\u00ean ng\u1eabu nhi\u00ean n\u1eb1m gi\u1eefa hai gi\u00e1 tr\u1ecb nh\u1ea5t \u0111\u1ecbnh. T\u00ean h\u00e0m l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a c\u1ee5m t\u1eeb Random Between, c\u00f3 ngh\u0129a l\u00e0 \u201cng\u1eabu nhi\u00ean trong kho\u1ea3ng gi\u1eefa\u201d.\u00a0<\/span><\/p>\n

C\u00fa ph\u00e1p: =RANDBETWEEN(bottom, top)<\/span><\/p>\n

Trong \u0111\u00f3:<\/span><\/p>\n