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 |
|---|---|---|
LN(1) | 0 | ln(1) equals 0. |
LN(45) | 3.80666... | ln(45) roughly equals 3.80666. |
LN(0.2) | -1.60943 | ln(0.2) roughly equals -1.60943. |
LN(-2) | BLANK | -2 is a negative number, the function returns BLANK. |
LN(EXP(2)) | 2 | As LN and EXP perform inverse operations, the output is the same as the input. |
See also
Excel: LN