LN

Formulas / LN
Calculate the natural logarithm of a number.
=LN(number)
  • number - the real number to calculate the natural logarithm of

Examples

  • LN(86)

    The LN function in Sourcetable returns the natural logarithm (ln) of a given number. For example, if we wanted to calculate the natural logarithm of 86, we would use the syntax above, which returns the value 4.453429.

  • LN(2.7182818)

    The LN function can also be used to calculate the natural logarithm of the value of a constant. For example, if you wanted to calculate the natural logarithm of the value of the constant 2.7182818, you would use the syntax above, which returns the value 0.9999999.

  • LN(EXP(3))

    The LN function can also be used to calculate the natural logarithm of the result of another function. For example, if you wanted to calculate the natural logarithm of the value of e raised to the power of 3, you would use the syntax above, which returns the value 3.


Summary

The LN function calculates the natural logarithm of a number based on the constant e. It takes a positive real number as an argument.

  • The LN function is the inverse of the EXP function, which models exponential decay.
  • The LN function takes a positive number as its argument.

Frequently Asked Questions

What is the LN function?
The LN function calculates the natural logarithm of a number.
What is the inverse of the LN function?
The inverse of the LN function is the EXP function.
What argument does the LN function take?
The LN function takes a real number as its argument.
Are there any restrictions on the argument for the LN function?
Yes, the argument must be positive.

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