EXCEL IMPOWER FUNCTION

The IMPOWER function in Excel returns a complicated number raised to a specified power.

Syntax :

=IMPOWER( inumbernumber )

Parameters :

  • The function parameters are as follows:

inumber –

  • The complex number to be raised to a certain power.

number –

  • The amount of power to be applied to the provided inumber.

Step By Step Guide of IMPOWER Function

Example :

The spreadsheets below demonstrate five applications of the Excel Impower function:

  • #NUM! – Occurs if the inumber given is not recognised as a complex number.
  • #VALUE! – This error occurs if either the specified inumber parameter is a boolean value or the given number is non-numeric.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now