Formualizer Docs
ReferenceFunctionsStatistics Functions

LOGNORM.DIST

LOGNORM.DIST: Returns the log-normal probability at `x` as either a cumulative value or density.

Summary

LOGNORM.DIST models positive-valued variables where ln(X) follows a normal distribution.

Remarks

  • Set cumulative to non-zero for CDF mode; set it to 0 for PDF mode.
  • Requires x > 0 and standard_dev > 0.
  • Returns #NUM! when x <= 0 or standard_dev <= 0.
  • Invalid numeric coercions propagate as spreadsheet errors.

Examples

Log-normal CDF at x = 1
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.5
Log-normal PDF at x = 1
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.3989422804014327

Runtime metadata

Category

Statistics

Signature

LOGNORM.DIST(arg1: Number, arg2: Number, arg3: Number, arg4: Number)

Arity

min 4, max 4

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

arg4

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

LOGEST

LOGEST: Returns parameters for an exponential model fitted to known data.

LOGNORM.INV

LOGNORM.INV: Returns the positive value `x` whose log-normal cumulative probability is `probability`.

On this page

SummaryRemarksExamplesRelated functionsRuntime metadata