Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with the specified parameters.
Name | Type | Description |
arg1 | number | A probability associated with the lognormal distribution, a number between 0 and 1, inclusive. |
arg2 | number | The mean of ln(x). |
arg3 | number | The standard deviation of ln(x), a positive number. |
builder.CreateFile("xlsx"); var oWorksheet = Api.GetActiveSheet(); var oFunction = Api.GetWorksheetFunction(); oWorksheet.GetRange("A1").SetValue(oFunction.LOGNORM_INV(0.3, 2, 0.2)); builder.SaveFile("xlsx", "LOGNORM_INV.xlsx"); builder.CloseFile();