{"id":24484,"date":"2021-05-13T08:49:42","date_gmt":"2021-05-13T01:49:42","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24484"},"modified":"2021-08-14T16:38:56","modified_gmt":"2021-08-14T09:38:56","slug":"ham-random-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-random-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Random trong Excel – C\u00f3 v\u00ed d\u1ee5"},"content":{"rendered":"

H\u00e0m Random (hay vi\u1ebft t\u1eaft l\u00e0 h\u00e0m Rand) trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean t\u1eeb 0 \u0111\u1ebfn 1. \u0110\u1ec3 t\u00ecm hi\u1ec3u chi ti\u1ebft c\u00fa ph\u00e1p c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Random trong Excel<\/strong> nh\u01b0 th\u1ebf n\u00e0o, b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o ti\u1ebfp b\u00e0i vi\u1ebft \u0111\u01b0\u1edbi \u0111\u00e2y c\u1ee7a Ben Computer.<\/p>\n

H\u00e0m Rand v\u00e0 h\u00e0m Random trong Excel<\/strong><\/h2>\n

Nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng cho r\u1eb1ng h\u00e0m Rand v\u00e0 h\u00e0m Random trong Excel<\/strong> l\u00e0 2 h\u00e0m kh\u00e1c nhau nh\u01b0ng th\u1ef1c ch\u1ea5t h\u00e0m Rand v\u00e0 Random ch\u1ec9 l\u00e0 m\u1ed9t h\u00e0m. H\u00e0m Rand (hay Random) n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean trong Excel.<\/p>\n

C\u00fa ph\u00e1p h\u00e0m Random trong Excel<\/strong><\/h3>\n

H\u00e0m Random trong Excel<\/strong> c\u00f3 c\u00fa ph\u00e1p, c\u00f4ng th\u1ee9c nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

=RAND()<\/strong><\/p><\/blockquote>\n

Kh\u00e1c v\u1edbi c\u00e1c h\u00e0m Excel kh\u00e1c, h\u00e0m Random (hay h\u00e0m Rand) kh\u00f4ng y\u00eau c\u1ea7u tham s\u1ed1. H\u00e0m tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean trong kho\u1ea3ng t\u1eeb 0 \u0111\u1ebfn 1.<\/p>\n

Ngo\u00e0i ra h\u00e0m Random t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt m\u1ed7i khi b\u1ea1n thay \u0111\u1ed5i, c\u1eadp nh\u1eadt gi\u00e1 tr\u1ecb b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Rand trong Excel<\/strong><\/h3>\n

H\u00e0m Rand Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ch\u1ee7 y\u1ebfu trong tr\u01b0\u1eddng h\u1ee3p khi ch\u00fang ta th\u1eed nghi\u1ec7m ph\u00e9p t\u00ednh c\u00f3 gi\u00e1 tr\u1ecb cho tr\u01b0\u1edbc b\u1ea5t k\u1ef3, l\u00e0 m\u1ed9t s\u1ed1 b\u1ea5t k\u1ef3 ho\u1eb7c ch\u1eef c\u00e1i b\u1ea5t k\u1ef3 trong b\u1ea3ng ch\u1eef c\u00e1i, \u2026 .<\/p>\n

\u0110\u1ec3 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Random trong Excel, b\u1ea1n \u0111\u1ecdc c\u00f9ng tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n

Gi\u1ea3 s\u1eed khi ch\u00fang ta nh\u1eadp c\u00f4ng th\u1ee9c, h\u00e0m Excel =RAND()<\/strong> v\u00e0o \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng t\u00ednh. M\u1ed7i khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt l\u1ea1i, h\u00e0m s\u1ebd c\u1eadp nh\u1eadt tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb kh\u00e1c nhau:<\/p>\n

\"H\u00e0m<\/p>\n

K\u1ebft qu\u1ea3 h\u00e0m Ran (hay h\u00e0m Random) tr\u1ea3 v\u1ec1 sau khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt l\u1ea1i c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n

\"C\u00e1ch<\/p>\n

M\u1ed9t s\u1ed1 l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Random trong Excel<\/strong><\/h3>\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng h\u00e0m Random trong Excel<\/strong>:<\/p>\n

    \n
  1. H\u00e0m Random s\u1ebd c\u1eadp nh\u1eadt v\u00e0 t\u00ednh to\u00e1n l\u1ea1i gi\u00e1 tr\u1ecb m\u1ed7i khi trang t\u00ednh, b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/li>\n
  2. \u0110\u1ec3 ng\u0103n gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean tr\u1ea3 v\u1ec1 t\u1eeb h\u00e0m Random trong Excel kh\u00f4ng thay \u0111\u1ed5i m\u1ed7i khi b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt, ch\u00fang ta nh\u1eadp h\u00e0m Excel c\u00f3 c\u00fa ph\u00e1p =RAND ()<\/strong>\u00a0v\u00e0o thanh Formula (c\u00f4ng th\u1ee9c) r\u1ed3i nh\u1ea5n\u00a0F9<\/strong>\u00a0l\u00e0 xong.<\/li>\n
  3. \u0110\u1ec3 t\u1ea1o t\u1eadp h\u1ee3p c\u00e1c s\u1ed1 ng\u1eabu nhi\u00ean trong nhi\u1ec1u \u00f4, d\u1ea3i \u00f4, t\u1ea5t c\u1ea3 nh\u1eefng g\u00ec b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 ch\u1ecdn c\u00e1c \u00f4 r\u1ed3i nh\u1eadp c\u00f4ng th\u1ee9c RAND()<\/strong>\u00a0r\u1ed3i nh\u1ea5n\u00a0Ctrl + Enter.<\/strong><\/li>\n
  4. Cu\u1ed1i c\u00f9ng \u0111\u1ec3 t\u1ea1o, tr\u1ea3 v\u1ec1 s\u1ed1 ng\u1eabu nhi\u00ean gi\u1eefa 2 s\u1ed1, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c RAND() * (b \u2013 a) + a,<\/strong>\u00a0trong \u0111\u00f3\u00a0a<\/strong>\u00a0l\u00e0 s\u1ed1 nh\u1ecf nh\u1ea5t v\u00e0\u00a0b<\/strong>\u00a0l\u00e0 s\u1ed1 l\u1edbn nh\u1ea5t m\u00e0 ch\u00fang ta mu\u1ed1n tr\u1ea3 v\u1ec1 s\u1ed1 ng\u1eabu nhi\u00ean.<\/li>\n
  5. \u0110\u1ec3 l\u01b0u gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean h\u00e0m Rand (), kh\u00f4ng mu\u1ed1n thay \u0111\u1ed5i gi\u00e1 tr\u1ecb n\u00e0y ch\u00fang ta ch\u1ec9 c\u1ea7n nh\u1ea5n F5 r\u1ed3i nh\u1ea5n Enter, gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean h\u00e0m Rand ()tr\u1ea3 v\u1ec1 s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u c\u1ed1 \u0111\u1ecbnh.<\/li>\n<\/ol>\n

    H\u00e0m Randbetween trong Excel<\/strong><\/h2>\n

    H\u00e0m Randbetween trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o m\u1ed9t s\u1ed1 ng\u1eabu nhi\u00ean trong m\u1ed9t kho\u1ea3ng, chu\u1ed7i gi\u00e1 tr\u1ecb cho tr\u01b0\u1edbc.<\/p>\n

    C\u00fa ph\u00e1p h\u00e0m Randbetween trong Excel c\u00f3 d\u1ea1ng:<\/p>\n

    RANDBETWEEN(bottom, top)<\/strong><\/p><\/blockquote>\n

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

    \u2013 Bottom<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): L\u00e0 s\u1ed1 nguy\u00ean nh\u1ecf nh\u1ea5t h\u00e0m RANDBETWEEN se\u0303 tra\u0309 v\u00ea\u0300.<\/p>\n

    \u2013 Top<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): L\u00e0 s\u00f4\u0301 nguy\u00ean l\u01a1\u0301n nh\u00e2\u0301t ma\u0300 ha\u0300m RANDBETWEEN se\u0303 tra\u0309 v\u00ea\u0300.<\/p>\n

    \"H\u00e0m
    H\u00e0m Randbetween trong Excel<\/figcaption><\/figure>\n

    L\u01b0u \u00fd:<\/strong><\/p>\n