^ , ** 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

 

See Also

Operators