The LN function returns the natural logarithm of a number.
Base is the constant e, approximately equal to 2.718.
This function is widely used in mathematics, physics, and statistics.
Syntax
LN(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
Value for which the natural logarithm is calculated |
Positive real number. Can be specified as a number, formula, function, or cell reference |
Example of use
Calculating the logarithm for the number 10
=LN(10)
Result: approximately 2.3025.
Calculate the logarithm of the number in the cell
If cell A1 contains the number 25:
=LN(A1)
Result: 3.22.
Calculating the logarithm for a negative number
=LN(−10)
Result: #NUM!.
Notes
The LN function is undefined for zero or negative numbers. If you try to calculate the logarithm of these values, the editor will return the #NUM! error.