# Documentation/Calc Functions/LN

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

LN

## Category:

Mathematical

## Summary:

Returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904.

## Syntax:

LN(**Number**)

## Returns:

Returns a real number.

## Arguments:

**Number** is the positive real number or reference to the cell containing that number whose natural logarithm is to be calculated.

If **Number** is negative or 0, then the function returns an error value.

## Additional details:

The formula used to calculate LN function is:

Where x is the **Number**

The figure below illustrates the LN function.

## Examples:

Formula | Description | Returns |
---|---|---|

=LN(3) | the natural logarithm of 3 | 1.09861228866811 |

=LN(EXP(321)) | the natural logarithm of e raised to the power 321 is itself | 321 |

=LN(-5) | function returns an error value since one of the arguments is negative | Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

LN