¦Û¤v¼g ¦Û¤vªº¤è¦¡²£¥Í¶Ã¼Æ
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¥»©«³Ì«á¥Ñ c_c_lai ©ó 2013-10-26 12:23 ½s¿è
¦^´_ 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:- Int ((10 - 1 + 1) * Rnd + 1) ' ¶Ç¦^¤¶©ó 1 ¨ì 10 ¶¡ªº¶Ã¼ÆÈ
- Int ((200 - 100 + 1) * Rnd + 100) ' ¶Ç¦^¤¶©ó 100 ¨ì 200 ¶¡ªº¶Ã¼ÆÈ
- Int ((600 - 300 + 1) * Rnd + 300) ' ¶Ç¦^ ¤¶©ó 300 ¨ì 600 ¶¡ªº¶Ã¼ÆÈ
½Æ»s¥N½X For example:- Sub Demo()
- Dim retNum As Integer
- retNum = Int ((300 - 200 + 1) * Rnd + 200)
- MsgBox "retNum ªº¶Ã¼ÆÈ = " & retNum
- End Sub
½Æ»s¥N½X In this example, the variable called retNum would now contain a random number between 200 and 300. |
|
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
|
|
|
|
|
|