VBA Functions: Numbers and Math
Find the list of all the main VBA functions on the VBA Functions page.
Numbers and Math
Abs | Returns the absolute value of a number. |
CInt / CLng | Converts a numeric value to an integer by rounding to the nearest integer. |
CSng / CDbl | Converts a numeric value to a floating-point number. |
Int / Fix | Returns the integer part of a number. |
RGB | Returns an integer corresponding to a color in RGB format. |
Rnd | Returns a random number less than 1 and greater than or equal to 0. |
Round | Rounds a number according to the specified number of decimals. |
Val | Returns the numbers contained in a string. |