Description
Returns the natural logarithm of a number. The natural logarithm uses the mathematical constant e (roughly equal to 2.71828) as base. It is the opposite of the EXP function.
Syntax
LN(Number)
Arguments
Argument | Type | Dimensions | Description |
|---|---|---|---|
Number (required) | Number | Any Dimensions | Number to return the natural logarithm for. |
Returns
Type | Dimensions |
|---|---|
Number | Dimensions of Number |
LN(0) returns BLANK.
Negative Numbers return BLANK.
Examples
Formula | Result | Description |
|---|---|---|
| 0 | ln(1) equals 0. |
| 3.80666... | ln(45) roughly equals 3.80666. |
| -1.60943 | ln(0.2) roughly equals -1.60943. |
|
| -2 is a negative number, the function returns |
| 2 | As |
See also
Excel: LN