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. |