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. |