¿¢¼¿±³½Ç
µÎ¼ö»çÀÌ¿¡ ³¼ö¸¦ ¹ß»ý½ÃÄÑ ¹«ÀÛÀ§ Ãß÷Çϱâ(RANDBETWEEN ÇÔ¼ö)
=RANDBETWEEN(½ÃÀÛ°ª, Á¾·á°ª)
RANDBETWEEN ÇÔ¼öÁ¦¸ñÀ» º¸¸é ¾î¶² ÇÔ¼öÀÎÁö ´ëÃæ ´À³¦ÀÌ ¿À½Ã³ª¿ä?
±×·¸½À´Ï´Ù RANDBETWEEN ÇÔ¼ö´Â µÎ¼ö »çÀÌ¿¡ ¼ýÀÚÇϳª¸¦ ¹«ÀÛÀ§·Î ¹ß»ý½ÃÅ°´Â ÇÔ¼öÀÔ´Ï´Ù.
=RANDBETWEEN(1, 100) À̶ó´Â ¼ö½ÄÀ» ¼¿¿¡ ³ÖÀ¸¸é 1°ú 100»çÀÌ¿¡ ÀÖ´Â ¼ýÀÚÇÑ°¡Áö¸¦ ÀÓÀÇ·Î ¹ÝȯÇÕ´Ï´Ù.
¿¹Á¦
¾Æ·¡ Ãß÷Â÷ ¸í´ÜÇ¥¿¡¼ 1¸íÀ» ¹«ÀÛÀ§ Ãß÷ÇÏ¿© ¹øÈ£¿Í À̸§À» ±¸Çغ¸¼¼¿ä.
Ãß÷ÀÚ ¸í´Ü 20¸íÁß¿¡¼ ÇÑ»ç¶÷¾¿ ¹«ÀÛÀ§·Î »Ì¾Æ³»¼ 3¸íÀ» »Ì¾Æ³»¸é µÇ´Âµ¥,
¾Õ¼ ¹è¿î RANDBETWEEN ÇÔ¼ö¸¦ ÀÌ¿ëÇØ F6¼¿¿¡ =RANDBETWEEN(1, 20) À̶ó°í ¼ö½ÄÀ» ÀÔ·ÂÇϸé
1°ú 20»çÀÌÀÇ ³¼ö¸¦ ¹ß»ý½Ãŵ´Ï´Ù. 8À̶ó´Â ³¼ö°¡ ¹ß»ýÇÏ¿´°í,
F7 ¼¿¿¡´Â INDEXÇÔ¼ö¸¦ ÀÌ¿ëÇÏ¿© INDEX(C3:C22, F6)À̶ó°í ÀÔ·ÂÇϸé
8¹ø° ÇØ´çÇÏ´Â À̸§Àº À̼öÁ¤À̶ó´Â À̸§À» È®ÀÎ ÇÒ ¼ö ÀÖ½À´Ï´Ù.