ReferenceFunctionsStatistics Functions

LOGNORM.INV

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

Summary

This function inverts LOGNORM.DIST(x, mean, standard_dev, TRUE).

Remarks

probability must be strictly between 0 and 1.
standard_dev must be strictly greater than 0.
Returns #NUM! when inputs violate probability or scale constraints.
Invalid numeric coercions propagate as spreadsheet errors.

Examples

Median log-normal quantile

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

1

Upper quantile for mean 0 and stdev 1

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

2.718281828459045

Runtime metadata

Category

Statistics

Signature

LOGNORM.INV(arg1: Number, arg2: Number, arg3: Number)

Arity

min 3, max 3

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

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

LOGNORM.DIST

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

MAXIFS

MAXIFS: Returns the maximum numeric value in a range that meets all criteria.

On this page

Summary Remarks Examples Related functions Runtime metadata