^ , ** Operators
Used to raise a number to the power of an exponent.
Syntax
result = expression1 ^expression2 |
result = expression1 **expression2 |
The ^ operator (** operator) syntax has these parts:
Part |
Description |
result |
Required; any numeric variable. |
expression1 |
Required; any expression. |
expression2 |
Required; any expression. |
Remarks
A number can be negative only if exponent is an integer value. When more than
one exponentiation is performed in a single expression, the ^ operator is evaluated
as it is encountered from right to left.
Usually, the data type of result is a Double or a Variant
containing a Double. However, if either number or exponent
is a Null expression, result is 1.
Example
This example uses the ^ operator to raise a number to the power of an exponent.
Dim MyValue MyValue = 2 ^ 2 ' Returns 4. trace MyValue MyValue = 3 ^ 3 ^ 2 ' Returns 19683. trace MyValue MyValue = (-5) ^ 3 ' Returns -125. trace MyValue |