# Documentation/Calc Functions/LOGINV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

LOGINV

## Category:

Statistical Analysis

## Summary:

Calculates the inverse of the cumulative distribution function for the log-normal distribution.

## Syntax:

LOGINV(**Number**[; **Mean**[; **StDev**]])

## Returns:

Returns a positive real number which is the inverse of the cumulative distribution function for the log-normal distribution.

## Arguments:

**Number** is a real number between 0 and 1 or a reference to a cell containing that number which is the probability value for which the inverse log-normal distribution is to be calculated.

**Mean** is a real number or a reference to the cell containing that number which is the mean value of the log-normal distribution. If omitted, the function assumes its value as 0.

**StDev** is a positive real number or a reference to the cell containing that number which is the standard deviation of the log-normal distribution. If omitted, the function assumes its value as 1.

- If
**Number**is greater than or equal to 1 or less than or equal to 0 then the function returns an error value. - If
**StDev**is negative or zero then the function returns an error value. - If any of the arguments passed is non-numeric or a reference to a cell containing that value then the function returns #VALUE! error.

## Additional details:

- It is such if that LOGNORMDIST(x;m;s;TRUE()) = p then LOGINV(p;m;s) = x

## Examples:

Formula | Description | Returns |
---|---|---|

=LOGINV(0.05;-0.5;1.5) | The function calculates the inverse of the cumulative distribution function for the log-normal distribution.Here we can check that LOGNORM.DIST(0.051443022632501;-0.5;1.5;TRUE()) gives 0.05. | 0.051443022632501 |

=LOGINV(1;-0.5;1.5) | The function returns an error value since the Number is greater than or equal to 1. |
Err:502 |

=LOGINV(-0.5;-0.5;1.5) | The function returns an error value since the Number is less than or equal to 0. |
Err:502 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

LOGINV