"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:uB****************@TK2MSFTNGP12.phx.gbl...
Where I can find the tutorial about numeric function..
e.g x = 15/6, i need to get the result (2) but not (2.5)
also get the reminder y = 15/6 , i can get the result (3)
if you want "15/6" to give you "2":
dim whole as Integer
whole = Int(15/6)
That will do the division, which will give you a real number (with possible
decimals), and just take the integer portion of the answer.
To get the remainder you need to do the MOD function:
dim remainder as Double
remainder = 15 Mod 6
remainder will now equal 3.