Number functions help the developers to handle numbers in an efficient way and also helps them to convert their subtypes. It also helps them to make use of the inbuilt mathematical functions associated with VBScript.
Number functions help us to convert a given number from one data subtype to another data subtype.
Sr.No | Function & Description |
---|---|
1 | CDbl A Function, which converts a given number of any variant subtype to double |
2 | CInt A Function, which converts a given number of any variant subtype to Integer |
3 | CLng A Function, which converts a given number of any variant subtype to Long |
4 | CSng A Function, which converts a given number of any variant subtype to Single |
5 | Hex A Function, which converts a given number of any variant subtype to Hexadecimal |
The Number formatting functions help the developers to express the given number in a format that they wish to.
Sr.No | Function & Description |
---|---|
1 | FormatNumber A Function, which would return an expression formatted as a number |
2 | FormatPercent A Function, which would return an expression formatted as a percentage |
Mathematical Functions help us to evaluate the mathematical and trigonometrical functions of a given input number.
Sr.No | Function & Description |
---|---|
1 | Int A Function, which returns the integer part of the given number |
2 | Fix A Function, which returns the integer part of the given number |
3 | Log A Function, which returns the natural logarithm of the given number. Negative numbers disallowed |
4 | Oct A Function, which returns the Octal value of the given percentage |
5 | Hex A Function, which returns the Hexadecimal value of the given number |
6 | Rnd A Function, which returns a random number between 0 and 1 |
7 | Sgn A Function, which returns a number corresponding to the sign of the specified number |
8 | Sqr A Function, which returns the square root of the given number. Negative numbers disallowed |
9 | Abs A Function, which returns the absolute value of the given number |
10 | Exp A Function, which returns the value of e raised to the specified number |
11 | Sin A Function, which returns sine value of the given number |
12 | Cos A Function, which returns cosine value of the given number |
13 | Tan A Function, which returns tan value of the given number |