Power function (exponential) in Excel
The Power function is a power function of a number of bases with a given exponent, if you are not familiar with the syntax or how to use the Power function, follow the article below.
The article describes the syntax and usage of the Power function in Excel.
Power function (exponential) in Excel Picture 1
Description
The Power function is the exponential function and returns the result as the power of a number.
Syntax
POWER (number, power)
Inside:
- number: the base number, is any real number and is a required argument.
- power: exponent, which is the number you want to raise the base to the power, required.
For example
Given the following data sheet:
Power function (exponential) in Excel Picture 2
Requirement: Power exponentiation with Power exponent.
Apply the POWER formula to cell D5: = POWER (B5, C5) .
Power function (exponential) in Excel Picture 3
Similarly for the following data will result as follows:
Power function (exponential) in Excel Picture 4
So, with the above examples, you can be sure of how to use the POWER function and apply the function to the right purpose of processing and calculating data in Excel spreadsheets. Good luck!
You should read it
- Exponential functions in Excel - Usage and examples
- The EXPON.DIST function - The function returns the exponential distribution in Excel
- GROWTH function - The function calculates the exponential growth value using existing data in Excel
- How to use the Power function in Excel
- How to write exponential numbers in Excel
- LOGEST - The function returns an array of data that describes an exponential curve that fits the data given in Excel
- Basic Excel functions that anyone must know
- How to use Hlookup function on Excel
- How to use the SUM function to calculate totals in Excel
- How to use the LEN function in Excel
- How to use the MROUND function in Excel
- How to use COUNTIF function on Excel
May be interested
The Text function converts a numeric value into text in Excel
Average function (calculate the average) in Excel
Find, FindB functions in Excel - The function finds a text string in another document in Excel
The INT (Function rounds a number down to the nearest integer of a number) in Excel
The Match function (the function searches for a specified value in an array or cell range) in Excel
The MODE function (returns the value with the most frequent occurrence in an array or data range) in Excel