LOGINV

Definition: LOGINV is a function that returns the inverse of the cumulative distribution function for a specified log-normal distribution.

Syntax: =LOGINV(probability, mean, standard_dev)

Situation: This formula is appropriate when you need to calculate the inverse of the cumulative distribution function for a log-normal distribution.

Example: If you have a log-normal distribution with a mean of 10 and a standard deviation of 2, and want to find the value that corresponds to a cumulative probability of 0.3, the formula =LOGINV(0.3, 10, 2) can be used, which returns 8.013.