（十四）常用函数

一、Int、Fix函数
Returns the integer portion of a number.

Remarks
Both Int and Fix remove the fractional part of number and return the resulting integer value.

The difference between Int and Fix is that if number is negative, Int returns the first negative integer less than or equal to number, whereas Fix returns the first negative integer greater than or equal to number. For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8.

当数字为正数时，截取整数部分；
当数字为负数时，①Int函数：获取小于等于当前值的数
②Fix函数：获取大于等于当前值的数

MyNumber = Int(99.8)    ' Returns 99.
MyNumber = Fix(99.2)    ' Returns 99.
MyNumber = Int(-99.8)   ' Returns -100.
MyNumber = Fix(-99.8)   ' Returns -99.
MyNumber = Int(-99.2)   ' Returns -100.
MyNumber = Fix(-99.2)   ' Returns -99.

二、Rnd函数

Dim upperbound,lowerbound,result
upperbound=8
lowerbound=2
Randomize   '初始化随机数
result=Int((upperbound-lowerbound+1)*Rnd+lowerbound)
Msgbox result

若不用Randomize，则会在当前页面不断重复运行是同一个运行结果；想要不同结果，则要关闭，再重新打开；使用Randomize则每次运行都是不同的结果