This function calculates the value of one number raised to the power of the other.
= POWER(base, power)
Base |
A number which is the base. The number can be specified as an integer (e.g., 37), as a decimal value (e.g., 37.48), as a string wit, or as the value of a variable (e.g, UnitPrice). |
Power |
A number which is the power. The number can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice). |
Decimal number.
In the case of an error, the function displays an error message: “POWER (dividend, divisor): Error message”
The function can be used in combination with other functions.
Example |
Returns |
= POWER(3, 2) |
9. |
= POWER(3, ““) |
1. |
= POWER(“$3”, 2) |
9. |
= POWER(UnitPrice, 2) |
The square of the unit price. |
= POWER(“abcd”, “efg”) |
Displays message “POWER(abcd, efg): Input string was not in a correct format.” |
= MODULUS(POWER(UnitPrice, 2), 3) |
The remainder of division between the square of UnitPrice and the number 3. |
= MAX(MODULUS(UnitPrice, 2), 1) |
The maximum value among remainder of division between UnitPrice and the number 2, and the number 1. |