ªð¦^¦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 : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD