# LOGINV

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the inverse of the lognormal cumulative distribution function of *x*, where [LN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLN)(*x*) is normally distributed with the specified mean and standard deviation.

## Syntax

LOGINV(*prob*,*mean*,*stdev*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *prob* | Value at which to evaluate the function |
| *mean* | Value of mean of natural logarithm of x, LN(x) |
| *stdev* | Value representing the standard deviation of LN(x) |

## Remarks

This function calculates the inverse of the lognormal cumulative distribution functions, so if *p* = LOGNORMDIST(*x*,...) then LOGINV(*p*,...) = *x*.

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`LOGINV(0.92,B8,G22)`
`LOGINV(0.88,2,1.2)` gives the result 30.26479297

## Version Available

This function is available in product version 1.0 or later.

## See Also

[LN](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLN) \| [LOGNORMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionLOGNORMDIST) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)