- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Math and Trignometric - POWER Function
Description
The POWER function returns the result of a number raised to a power.
Syntax
POWER (number, power)
Arguments
| Argument | Description | Required/Optional |
|---|---|---|
| Number | The base number. It can be any real number. |
Required |
| Power | The exponent to which the base number is raised. | Required |
Notes
The "^" operator can be used instead of POWER to indicate to what power the base number is to be raised, such as in 5^2
The number and power arguments are numerical values that can be supplied to the Function either directly or as values returned from other functions or as references to cells containing numbers.
If either of the specified arguments is non-numeric, POWER returns #VALUE! Error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements