Power function (exponential) in Excel

Power function (exponential) in Excel - Power function is a power function of a number of bases with a given exponent, if you do not understand the syntax or how to use the Power function, you follow the article write below.

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 1Power 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 2Power 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 3Power function (exponential) in Excel Picture 3

Similarly for the following data will result as follows:

Power function (exponential) in Excel Picture 4Power 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!

4 ★ | 1 Vote