Check Sheet Logo
Check Sheet

IMLN

The IMLN function returns the natural logarithm of a complex number. It takes one required parameter, complex_value, which is the complex number for which to calculate the natural logarithm.

Usage

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

=IMLN(complex_value)
Parameters:
  1. complex_value (required):
    The complex number for which to calculate the natural logarithm.

Examples

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

Calculate the natural logarithm of a complex number

The IMLN function can be used to find the natural logarithm of a complex number, which is useful in a variety of mathematical applications.

Perform complex number operations

The IMLN function is often used in combination with other complex number functions, such as IMAGINARY and REAL, to perform complex number operations.

Convert between polar and rectangular coordinates

The IMLN function can be used in conjunction with other complex number functions to convert between polar and rectangular coordinates.

Common Mistakes

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

Incorrect number of arguments

The IMLN formula requires one argument, which is the complex value. Make sure you are not providing too many or too few arguments.

Invalid input value

The IMLN formula can only accept complex numbers as input. Check that the input value is in the correct format and does not contain any non-numeric characters.

Incorrect format of output

The output of the IMLN formula is in the form of a complex number. If the output is not in this format, check that the input value is valid and that the formula is written correctly.

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

  • 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.

  • IMARGUMENT

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

  • 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 IMLN Google Sheets function on Google Support.