EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel POWER Function in Excel
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

POWER Function in Excel

By Jeevan A YJeevan A Y

POWER in Excel

POWER in Excel (Table of Contents)

  • POWER in Excel
  • POWER Formula in Excel
  • How to Use POWER Function in Excel?

POWER in Excel

I still remember the days when my maths teacher beat me almost every day for not remembering the SQUARE ROOT of numbers. I literally cried when maths period is on the way. There are many instances where I bunked the math class just to get away from those beatings from my maths teacher.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Ok, now I need not to remember all those SQUARE ROOTS; instead, I can rely on a beautiful function called the POWER Function.

POWER function helps in raising the number to another number of times to the power.

For example: What is the value of 5 to the square of 3? The answer is 5*5*5 = 125.

POWER Formula in Excel

Below is the POWER Formula:

POWER Formula in Excel

The Power Function includes two parameters, and both are required arguments.

  • Number: The number you need to raise the power, i.e. the base number of any real number.
  • Power: The number of times you need to raise the base number. It is the exponent to raise the base number.

The symbol or operator ^ (caret operator) acts as an exponent. For example: 6^2 = 36. This is not 6 is multiplied by 2 rather 6 * 6 = 36. Six is multiplied by the six itself twice.

POWER Formula in Excel example

The simple equation is 5 * 5 * 5 * 5 = 625

How to Use the POWER Function in Excel?

This POWER function is very simple easy to use. Let us now see how to use the POWER Function with the help of some examples.

You can download this POWER Function in Excel Template here – POWER Function in Excel Template

Example #1

Assume you have base numbers from A2:A6 and the power number (exponential numbers) from B2:B6. Show the power of values in column A by using power numbers in column B.

Example 1-1

Apply Power formula in the cell C2

POWER Example 1-2

The answer will be:

POWER Example 1-3

Drag and drop the formula to other cells.

POWER Example 1-4

  • The first value is base number 8 is raised to the power number 3. i.e. 8 cube. =8*8*8 = 512.

Secondly, base number 11 is raised to the power number 6, i.e. 11 is multiplied 6 times to the 11 itself. =11 * 11* 11* 11* 11* 11 = 17, 71,561. Similarly, all the values have resulted in that way.

Example #2

Use the same data from the above example. Instead of using the POWER Function, we use the caret operator (^) to do the calculation. The results will be the same, though.

Example 2-1

Apply formula in the cell H2

POWER Example 2-2

The answer will be:

POWER Example 2-3

Drag and drop the formula to other cells.

POWER Example 2-4

Example #3

Using POWER Function along with other functions. From the below data, raise all the even numbers power by 2; if the number is not even, then raise the power by 5.

Here, first, we need to test whether the number is even or not. If the number found, raise the power by 2; if not, raise the power by 5.

Example 3-1

This type of problem can be addressed by using the IF condition to test whether the number is even or not.

Apply formula in cell B2.

POWER Example 3-2

The answer will be:

POWER Example 3-3

Drag and drop the formula to other cells.

POWER Example 3-4

  • IF condition tests whether the supplied number is equal to an even number or not. =IF(A2=EVEN(A2),
  • If the IF logic is true then the POWER function will raise the power by 2. =POWER(A2,2),
  • If the IF logic is false, then the POWER function will raise the power by 5. =POWER(A2,5),

POWER Function in VBA

In VBA, also we can use the POWER function. However, the thing is, we do not get to see many of these live examples in our day-to-day life.

Step 1: Open your VBA editor (ALT + F11).

VBA Editor

Step 2: Go to insert and insert Module. This would instantly create a new module to write our code for the POWER function.

Insert Module in VBA 2

Step 3: Copy and paste the below code inside the new module.

Sub Power_Function_Example ()
Dim My_Result As String
My_Result = Application.WorksheetFunction.Power(6, 3)
MsgBox My_Result
End Sub

Now your window should look like the one below one.

POWER in VBA 3

If you run the code, you will get the below result.

POWER in VBA 4

Things to Remember about POWER Function

  • For a better understanding, we can represent the power function in this way. POWER(X, Y) or POWER(X^Y) both are the same only.
  • The POWER function is applied only for numerical values. Anything other than numerical values, it will throw the error as #VALUE! If any one of the parameters contains non-numerical values, we will get the error. The below image shows an example of the error.

POWER Example 4-1

It will show an error.

VALUE Error Example 4-2

Recommended Articles

This has been a guide to POWER Function. Here we discuss the POWER Formula and how to use the POWER Function along with practical examples and downloadable excel templates. You can also go through our other suggested articles –

  1. How to Use FIND Function in Excel?
  2. Excel NOT Function
  3. TRANSPOSE Excel Function
  4. LOOKUP in MS Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download POWER Function in Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download POWER Function in Excel Template

EDUCBA

डाउनलोड POWER Function in Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more