¦Û¤v¼g ¦Û¤vªº¤è¦¡²£¥Í¶Ã¼Æ

sjgau

¤@¬íÄÁ¡A¥i¥H°õ¦æ·þ¤Ö­Ó ®aªkªº¹Bºâ¡H

¤@¬íÄÁ¡A¥i¥H²£¥Í¦h¤Ö­Ó¶Ã¼Æ¡H

À\²q¬Ý

sunnyso

¦^´_ 1# sjgau


  ´Á«Ý¸Ñ»¡

sjgau

¦^´_ 2# sunnyso


    ¥ý¸ÑÄÀ¡A¬°¦ó­n ¦Û¤v¼g

¤@ ¦Û¤v¥Íªº¤p«Ä¡A¤~¥i¥H¥´

¤G ±q¼g§@ªº ¹Lµ{¡A¥i¥Hµo²{«Ü¦h°ÝÃD©M ¾Ç°Ý

·q½Ð´Á«Ý

sunnyso

¦^´_ 3# sjgau

´Á«Ýing + Ãöª`ing

c_c_lai

¦^´_ 4# sunnyso
VBA Function Example

The RND function can only be used in VBA code in Microsoft Excel.
Here are some examples of what the RND function would return:

1.     Int ((10 - 1 + 1) * Rnd + 1)     '   ¶Ç¦^¤¶©ó 1 ¨ì 10 ¶¡ªº¶Ã¼Æ­È
   
2.     Int ((200 - 100 + 1) * Rnd + 100)   '  ¶Ç¦^¤¶©ó 100 ¨ì 200 ¶¡ªº¶Ã¼Æ­È
   
3.     Int ((600 - 300 + 1) * Rnd + 300) '  ¶Ç¦^ ¤¶©ó 300 ¨ì 600 ¶¡ªº¶Ã¼Æ­È

½Æ»s¥N½X

For example:

1. Sub Demo()
   
2.     Dim retNum As Integer
   
3. 
   
4.     retNum = Int ((300 - 200 + 1) * Rnd + 200)
   
5.     MsgBox "retNum ªº¶Ã¼Æ­È = " & retNum
   
6. End Sub

½Æ»s¥N½X

In this example, the variable called retNum would now contain a random number between 200 and 300.

sjgau

¤£­ã ¨Ï¥Î rnd

ML089

¦^´_ 6# sjgau


  ¶Ã¼Æ¤£­ã¨Ï¥Î rnd ­n¦p¦ó¨Ï¥Î ? ´Á«Ý

sjgau

http://en.wikipedia.org/wiki/Linear_congruential_generator

¤W­±©Ò¤¶²Ðªº¬O ¥Ø«e«Ü¬y¦æªº²£¥Í¶Ã¼Æªº¤èªk¤§¤@
½u©Ê¦P¾l¡C
§Ú²ßºD¨Ï¥Î Apple Lab. ªº«Y¼Æ
R(n)= (R(n-1)*A + B) MOD C

A= 7^5= 16807,
B= 0
C= (2^31) - 1 = 2147483647

sunnyso

¦^´_ 8# sjgau

¤£¬O«ÜÀ´, ¥i§_¥Îvba ¼g¤@¬qcode? ÁÂÁÂ

sjgau

¦^´_ 9# sunnyso


    OK

µ¥§Ú 11/8 ¤é¥»¦^¨Ó ¦A»¡