LOGINV

Try it

When to use it

When should I use LOGINV?

Use LOGINV to find the value at which the lognormal cumulative distribution equals a given probability — useful for modeling positively skewed quantities such as asset prices or biological measurements. LOGINV is the legacy alias for LOGNORM.INV; prefer LOGNORM.INV in new work.

Used in

science · finance

Syntax

LOGINV(p,mean,stdev)

Examples

=LOGINV(0.4,4,6) // => 11.940277905248184