How to Use IMPOWER Function in Excel 365? – [with Examples]
Tags: excelfunctions, impowerfunctioninexc
Published: 2020-08-21 16:43:45

---
title: How to Use IMPOWER Function in Excel 365? – [with Examples]
published: true
date: 2020-08-14 12:12:53 UTC
tags: ExcelFunctions,IMPOWERFunctioninExc
canonical_url: https://geekexcel.com/how-to-use-impower-function-in-excel-365-with-examples/
---

## IMPOWER Function in Excel:

In this post, we are going to explore the usage of ** IMPOWER Function in Excel 365** with its syntax, description, and examples. Let’s get started!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

 

## **IMPOWER – Function Description:**

- The **IMPOWER Function ** returns a complex number (X+Yi or X+Yj) raised to a given number.
- X and Y are real numbers, and i or j is an imaginary number.
- **X** is a **real** part, **Yi** is an **imaginary** part.
- You can use a COMPLEX Function to convert real and imaginary coefficients to a complex number.

## **Syntax:**

=**IMPOWER(inumber, number)**

### Argument Explanation:

**Inumber** – A complex number which you want to raise a power.

**Number** – It is a Power to raise a complex number.

### **Note:**

- You can use the COMPLEX function to convert real and imaginary coefficients to a complex number.
- If the number is a non-numeric value ( **letters and special characters** ), it returns **#VALUE!** Error.
- You can give the integer, fractional, and negative values to the number argument.
- Only “i” or “j” is allowed to use in this function, other values will return **#NUM!** Error.
- To calculate IMPOWER function, the below formula will be used and so refer to the below image.

![IMPOWER Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-10.png)<figcaption id="caption-attachment-11758">IMPOWER Formula</figcaption>

## **Examples:**

Let’s see some examples below.

### Example 1:

- Refer to the following screenshot.
- You can see the Complex numbers ( **inumber** ) in **Column A** and their Power values ( **number** ) in **Column B**. Then, the output values in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-32.png)<figcaption id="caption-attachment-11730">Example 1</figcaption>

### Example 2:

- If the number is a non-numeric value ( **letters and special characters** ), it returns **#VALUE!** Error.
- Now, see the below image.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-23.png)<figcaption id="caption-attachment-11732">Example 2</figcaption>

**Example 3:**

- Only “i” or “j” is allowed to use in this function, other values will return **#NUM!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-21.png)<figcaption id="caption-attachment-11733">Example 3</figcaption>

## **Verdict:**

To sum up, hope this article guided you to learn the usage of **IMPOWER Function in Excel 365** with its syntax, description, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- **IMSUM Function**
- **IMSUB Function**
- **IMREAL Function**
- **IMPRODUCT Function**

### Keep Reading:

- [How to Use BITXOR Function in Microsoft Excel 365? – [With Examples]](https://geekexcel.com/how-to-use-bitxor-function-in-microsoft-excel-365-with-examples/)
- [How to Use “DEC2HEX Function” in MS Excel 365? – [With Examples]](https://geekexcel.com/how-to-use-dec2hex-function-in-ms-excel-365-with-examples/)