Formualizer Docs
ReferenceFunctionsMath Functions

LN

LN: Returns the natural logarithm of a positive number.

Summary

Returns the natural logarithm of a positive number.

Remarks

  • number must be greater than 0; otherwise the function returns #NUM!.
  • LN(EXP(x)) returns x up to floating-point precision.
  • Input errors are propagated.

Examples

Natural log of e cubed
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3
Natural log of a fraction
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-0.6931471805599453

FAQ

Why does LN return #NUM! for 0 or negatives?

Natural logarithm is only defined for strictly positive inputs.

Runtime metadata

Category

Math

Signature

LN(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

LCM

LCM: Returns the least common multiple of one or more integers.

LOG

Returns the logarithm of a number for a specified base.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does LN return #NUM! for 0 or negatives?Runtime metadata