POWER function in Excel

What is POWER function in Excel?

The POWER function is one of the math functions of Excel.

It Returns the result of a number raised to a power.

We can find this function in Math & trig of insert function Tab.

How to use POWER function in excel

  1. Click on an empty cell (like F5 )
an empty cell in excel

2. Click on the fx icon (or press shift+F3)

 fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select POWER function

6. Then select ok

excel  POWER function

7. In the function Arguments Tab you will see POWER Value

8. Number is the base number, any real number

9. Power is the exponent, to which the base number is raised

10. You will see results in the formula result section

How to use POWER function in excel

Examples of POWER function in excel

Example 1:

How to use POWER function in excel

You can see examples of POWER function below:

Examples of POWER function in excel
power(A2,B2) ----->>>>answer is  2

power(A3,B3) ----->>>>answer is  4

power(A4,B4) ----->>>>answer is  8

power(A5,B5) ----->>>>answer is  16

power(A6,B6) ----->>>>answer is  32

What is the purpose of POWER function?

It Returns the result of a number raised to a power.

What is the Return value of POWER function?

It returns a number.

How many arguments does POWER function have?

This function has just 2 Argument.

The argument of POWER function is number.

Number is the base number, any real number.

Power is the exponent, to which the base number is raised.

The argument of POWER function is required and not optional.

POWER(number) = number

Which version of excel supports POWER function?

This function is available for all excel versions (2003-2019)

Errors in POWER function

POWER related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *