Check Sheet Logo
Check Sheet

IMARGUMENT

The IMARGUMENT function returns the argument corresponding to the given number in a complex number in rectangular form.

Usage

Use the IMARGUMENT formula with the syntax shown below, it has 1 required parameter:

=IMARGUMENT(number)
Parameters:
  1. number (required):
    A number between 1 and 2 specifying which argument to return. If number is not an integer, it is truncated.

Examples

Here are a few example use cases that explain how to use the IMARGUMENT formula in Google Sheets.

Extract the real part of a complex number

To extract the real part of a complex number in rectangular form, use IMARGUMENT with number set to 1.

Extract the imaginary part of a complex number

To extract the imaginary part of a complex number in rectangular form, use IMARGUMENT with number set to 2.

Calculate the argument of a complex number

To calculate the argument of a complex number in rectangular form, use IMARGUMENT with number set to 1 and the imaginary part of the complex number divided by the real part.

Common Mistakes

IMARGUMENT not working? Here are some common mistakes people make when using the IMARGUMENT Google Sheets Formula:

Incorrectly entering the argument

Make sure to provide the correct syntax and argument to the function, otherwise it will return an error.

Using non-complex numbers

The IMARGUMENT function can only be used with complex numbers in x + yi or x + yj text notation.

The following functions are similar to IMARGUMENT or are often used with it in a formula:

  • IMREAL

    Returns the real coefficient of a complex number in x+yi or x+yj text format.

  • IMAGINARY

    The IMAGINARY function in Google Sheets returns the imaginary coefficient of a given complex number. The imaginary coefficient is the part of the complex number that is multiplied by the imaginary unit. This function is often used in engineering and scientific applications that involve complex numbers.

  • IMABS

    The IMABS function returns the absolute value (modulus) of a complex number. This is useful when working with complex numbers in engineering or scientific calculations.

  • IMCONJUGATE

    The IMCONJUGATE formula returns the complex conjugate of a given complex number. This formula is commonly used in engineering and physics calculations involving complex numbers.

Learn More

You can learn more about the IMARGUMENT Google Sheets function on Google Support.