ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Ãö©óRAND¥Îªkªº°ÝÃD

Ãö©óRAND¥Îªkªº°ÝÃD

½Ð±Ð¤j¤j¤@­Ó°ÝÃD

§Ú³]A1¬°¤@²Õ120~150ÀH¾÷ªº«K¼Æ
©Ò¥H§Ú³]
A1 =(RAND()*30+120)
§Ú³]B1¬°¤@²Õ100~150ÀH¾÷ªº«K¼Æ
B1=(RAND()*50+100)

§Ú¥d¦íªº¦a¤è¬OB1 ¤£¥i¥H¤j©óA1¥B¤ñA1¤Ö10

¦pªGA1=120,¨ºB1´N­n¤p©ó120¤S¤Ö10

«K¦¨
A1=120
B1=110

½Ð°Ý­n«ç»ò¦ê°_¨Ó

¥»©«³Ì«á¥Ñ p212 ©ó 2013-8-14 22:23 ½s¿è

¦^´_ 1# v60i
½Ð°Ý¦b¡uB1 ¤£¥i¥H¤j©óA1¥B¤ñA1¤Ö10¡v±ø¥ó¤U¡A¨º¨Ï¥ÎB1=A1-10¡]§YB1 =(RAND()*30+110)¡^¤£¥i¥H¡H

TOP

¦^´_ 2# p212


    §Úª¾¹D³o­Ó¤èªk

¦ý¬O³o¼Ë´NÅܱo«Ü³W«ß

¤£ºÞA1¬O¦h¤ÖB1¥Ã»·³£¬O¤Ö10

§Ú§Æ±æªº¬O¥i¥H¤£­n¦³³o­Ó©ë§ô

B1¥i¥H¤Ö10¥i¥H¤Ö20 ¥i¥H10¥H¥~ªº¥ô¦ó¼Æ

TOP

¦^´_ 3# v60i


B1=RANDBETWEEN(100,A1-10)

¦pªG¬O³o¼Ë¥i¥H¶Ü?

TOP

¦^´_ 4# lukychien


    ¥i¥H.ÁÂÁ¤j¤j

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD