<![CDATA[
<p> <br></p><p><br></p><p><iframe id="uX-gE8sMCQU$@my" width="640" height="360" src="https://kakaotv.daum.net/embed/player/cliplink/uX-gE8sMCQU$@my?service=daum_cafe&ptoken=v2_b9f9e959ee169870f0ad09908b9d9919997d7eed4410b3a7db2e1e42bdc5d8d3eea1a68a14e50149613bcf770ca700231fd984a3cd1ad034674af193" frameborder="0" scrolling="no" allowfullscreen></iframe></p><p>
<br></p><p>무작위(random)로 숫자를 추출하는 함수</p>
<p>랜덤으로 아무 숫자나 나오게 하는 함수</p>
<p> </p>
<p>(예) 1에서 5까지 아무 숫자나 나오게 하시오.</p>
<p>=RANADBETWEEN(1,5)</p>
<p> </p>
<p>
<table style="width: 337pt; border-collapse: collapse;" width="448" border="0" cellpadding="0" cellspacing="0">
<colgroup>
<col style="width: 101pt;" width="134">
<col style="width: 48pt;" width="64" span="2">
<col style="width: 140pt;" width="186">
</colgroup><tbody>
<tr style="height: 13.5pt;" height="18">
<td class="xl68" style="border: medium none rgb(236, 233, 216); width: 101pt; height: 13.5pt; background-color: transparent;" width="134" height="18"><strong><font color="#000000" face="맑은 고딕" size="2">청소당번정하기</font></strong></td>
<td class="xl68" style="border: medium none rgb(236, 233, 216); width: 48pt; background-color: transparent;" width="64"><strong></strong><br></td>
<td class="xl68" style="border: medium none rgb(236, 233, 216); width: 48pt; background-color: transparent;" width="64"><strong></strong><br></td>
<td style="border: medium none rgb(236, 233, 216); width: 140pt; background-color: transparent;" width="186"><font color="#000000" face="맑은 고딕" size="2">=RANDBETWEEN(1,5)</font></td></tr>
<tr style="height: 13.5pt;" height="18">
<td class="xl68" style="border: medium none rgb(236, 233, 216); height: 13.5pt; background-color: transparent;" height="18"><br></td>
<td class="xl68" style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td class="xl68" style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr>
<tr style="height: 20.25pt;" height="27">
<td class="xl69" style="border: 0.5pt solid windowtext; height: 20.25pt; background-color: yellow;" height="27">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2"><strong>오늘의 청소당번은?</strong></font></p></td>
<td class="xl70" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; background-color: rgb(221, 217, 195);">
<p style="text-align: center;"><strong><font color="#000000" face="맑은 고딕" size="5">2</font></strong></p></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><strong></strong><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><font color="#000000" face="맑은 고딕" size="2">F9를 누르면 재계산이 된다.</font></td></tr>
<tr style="height: 13.5pt;" height="18">
<td style="border: medium none rgb(236, 233, 216); height: 13.5pt; background-color: transparent;" height="18"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr>
<tr style="height: 13.5pt;" height="18">
<td class="xl71" style="border: 0.5pt solid windowtext; height: 13.5pt; background-color: rgb(31, 73, 125);" height="18"><font color="#ffffff" face="맑은 고딕" size="2">번호</font></td>
<td class="xl71" style="border-style: solid solid solid none; border-color: windowtext; border-width: 0.5pt 0.5pt 0.5pt medium; background-color: rgb(31, 73, 125);"><font color="#ffffff" face="맑은 고딕" size="2">성명</font></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr>
<tr style="height: 13.5pt;" height="18">
<td class="xl66" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 13.5pt; background-color: transparent;" height="18">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">1</font></p></td>
<td class="xl65" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">김영철</font></p></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr>
<tr style="height: 13.5pt;" height="18">
<td class="xl66" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 13.5pt; background-color: transparent;" height="18">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">2</font></p></td>
<td class="xl65" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">이순재</font></p></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr>
<tr style="height: 13.5pt;" height="18">
<td class="xl66" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 13.5pt; background-color: transparent;" height="18">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">3</font></p></td>
<td class="xl65" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">장동건</font></p></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr>
<tr style="height: 13.5pt;" height="18">
<td class="xl66" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 13.5pt; background-color: transparent;" height="18">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">4</font></p></td>
<td class="xl65" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">김형돈</font></p></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr>
<tr style="height: 13.5pt;" height="18">
<td class="xl66" style="border-style: none solid solid; border-color: windowtext; border-width: medium 0.5pt 0.5pt; height: 13.5pt; background-color: transparent;" height="18">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">5</font></p></td>
<td class="xl65" style="border-style: none solid solid none; border-color: windowtext; border-width: medium 0.5pt 0.5pt medium; background-color: transparent;">
<p style="text-align: center;"><font color="#000000" face="맑은 고딕" size="2">유재석</font></p></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td>
<td style="border: medium none rgb(236, 233, 216); background-color: transparent;"><br></td></tr></tbody></table></p>
<p> </p>
<p> </p>
<!-- -->
]]>
카페 게시글
엑셀 함수 공부하기
RANDBETWEEN함수
가고파
추천 0
조회 143
10.01.12 10:53
댓글 2
다음검색
첫댓글 재밌네요^^ 그런데 이순재씨는 연세많으신데 청소에서 제외시켜주세요^^
사다리타기의 변형으로 쓰면 재밌겠어요