@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
- This example returns 8 (2 raised to the power of 3, or 23).
@Power(2;3) - This example returns -8 (-2 raised to the power of 3, or -23).
@Power(-2;3) - This example returns 0.125 (2 raised to the power of -3, or 2-3).
@Power(2;-3) - This example returns 8 and -8 in a list.
@Power(2 : -2; 3)