@Power (Formula Language)

Raises a number to the power of an exponent.

Syntax

@Power( base ; exponent )

Parameters

base

Number or number list. The value that you want raised to exponent. May be positive or negative.

exponent

Number or number list. The power.

Return value

result

Number or number list. The value of base raised to the power of exponent.

Usage

If either parameter is a list, the function operates pair-wise on each element of the list, and the return value is a list with the number of elements in the larger list.

Examples

  1. This example returns 8 (2 raised to the power of 3, or 23).
    @Power(2;3)
  2. This example returns -8 (-2 raised to the power of 3, or -23).
    @Power(-2;3)
  3. This example returns 0.125 (2 raised to the power of -3, or 2-3).
    @Power(2;-3)
  4. This example returns 8 and -8 in a list.
    @Power(2 : -2; 3)