IMPOWER

Formulas / IMPOWER
Raise a complex number to a given power.
==IMPOWER(inumber, number)
  • inumber - required, complex number
  • number - required, power to raise the complex number to

Examples

  • =IMPOWER("2+3i", 3)

    The function can be used to raise a complex number to a power. For example, returns -46, whithisch is 2+3i (raised to the power of 3).

  • =IMPOWER(-2, 4)

    The function can also be used to raise a negative number to a power. For example, this returns 16, which is -2 raised to the power of 4.

  • =IMPOWER(-2, -3)

    The function can also be used to raise a negative number with a negative exponent to a power. For example, this formula returns -0.125, which is -2 raised to the power of -3.


Summary

The IMPOWER function is used to raise a complex number to a power, returning the result in text format x + yi or x + yj. Both the inumber and number arguments are required, and must be complex numbers.

  • The IMPOWER function returns a complex number in the form x + yi or x + yj.
  • The COMPLEX function creates a complex number from real and imaginary parts that can be supplied as arguments to the IMPOWER function.

Frequently Asked Questions

What is the IMPOWER function?
The IMPOWER function is a function which returns a complex number after it has been raised to a power. The complex number is formatted as either x + yi or x + yj.
What arguments are required for this function?
The two arguments required for this function are the inumber and number arguments. Both these arguments must be complex numbers to be raised to a power.
What is the output of the IMPOWER function?
The output of the IMPOWER function is a complex number which has been raised to a power.
What is the format of the output of the IMPOWER function?
The output is formatted as either x + yi or x + yj.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV