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 Conversion Functions
Number functions help us to convert a given number from one data subtype to another data subtype.
Show Examples
Sr.No | Function & Description |
---|---|
1 | CDblA Function, which converts a given number of any variant subtype to double |
2 | CIntA Function, which converts a given number of any variant subtype to Integer |
3 | CLngA Function, which converts a given number of any variant subtype to Long |
4 | CSngA Function, which converts a given number of any variant subtype to Single |
5 | HexA Function, which converts a given number of any variant subtype to Hexadecimal |
Number Formatting Functions
The Number formatting functions help the developers to express the given number in a format that they wish to.
Show Examples
Sr.No | Function & Description |
---|---|
1 | FormatNumberA Function, which would return an expression formatted as a number |
2 | FormatPercentA Function, which would return an expression formatted as a percentage |
Mathematical Functions
Mathematical Functions help us to evaluate the mathematical and trigonometrical functions of a given input number.
Sr.No | Function & Description |
---|---|
1 | IntA Function, which returns the integer part of the given number |
2 | FixA Function, which returns the integer part of the given number |
3 | LogA Function, which returns the natural logarithm of the given number. Negative numbers disallowed |
4 | OctA Function, which returns the Octal value of the given percentage |
5 | HexA Function, which returns the Hexadecimal value of the given number |
6 | RndA Function, which returns a random number between 0 and 1 |
7 | SgnA Function, which returns a number corresponding to the sign of the specified number |
8 | SqrA Function, which returns the square root of the given number. Negative numbers disallowed |
9 | AbsA Function, which returns the absolute value of the given number |
10 | ExpA Function, which returns the value of e raised to the specified number |
11 | SinA Function, which returns sine value of the given number |
12 | CosA Function, which returns cosine value of the given number |
13 | TanA Function, which returns tan value of the given number |