Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x.
| Name | Type | Description |
| arg1 | number | The probability associated with the gamma distribution, a number between 0 and 1, inclusive. |
| arg2 | number | The alpha parameter of the distribution, a positive number. |
| arg3 | number | The beta parameter of the distribution, a positive number. If this parameter is equal to 1, the function returns the standard gamma distribution. |
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var ans = oFunction.GAMMA_INV(0.4, 9, 2);
oWorksheet.GetRange("B2").SetValue(ans);
builder.SaveFile("xlsx", "GAMMA_INV.xlsx");
builder.CloseFile();