^ (operator)

Syntax

expression1 ^ expression2

Description

Returns expression1 raised to the power specified in expression2.

Comments

The following are special cases:

 

Special Case

Value

 

n^0

1

 

0^-n

Undefined

 

0^+n

0

 

1^n

1

 

The type of the result is always Double, except with Boolean expressions, in which case the result is Boolean. Fractional and negative exponents are allowed.

If either expression is a Variant containing NULL, then the result is NULL.

It is important to note that raising a number to a negative exponent produces a fractional result.

Example

Sub Main()
  s# = 2 ^ 5        'Returns 2 to the 5th power.
  r# = 16 ^ .5      'Returns the square root of 16.
  MsgBox "2 to the 5th power is: " & s#
  MsgBox "The square root of 16 is: " & r#
End Sub

See Also

Operator Precedence (topic).

More information

Symbols