LOGNORM.INV

Try it

When to use it

When should I use LOGNORM.INV?

Use LOGNORM.INV to find the value at which the lognormal cumulative distribution equals a given probability p — for example, the 90th-percentile expected return or the latency threshold that 95% of requests fall under.

Used in

science · finance

Syntax

LOGNORM.INV(p,mean,stdev)

Examples

=LOGNORM.INV(0.4,4,6) // => 11.940277905248184