@Ln (Formula Language)

Returns the natural log of a number. Natural logs use e (approximately 2.718282) as their base.

Syntax

@Ln( number )

Parameters

number

Number or number list. May be any value greater than 0, and can contain up to 15 decimal places.

Return value

naturalLog

Number or number list. The natural log of number.

Usage

If the parameter is a list, the function operates on each element of the list, and the return value is a list with the same number of elements.

Use @Ln in formulas requiring natural logs, such as compound growth or loss.

@Ln is the inverse of @Exp.

Examples

  1. This example returns 0.693147180559945.
    @Ln(2)
  2. This example returns 0.693147180559945 and 1.38629436111989 in a list.
    @Ln(2 : 4)