- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Compatibility - NORMSINV Function
The NORMSINV function replaces the NORM.S.INV function in Excel 2010.
Description
The function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
Syntax
NORMSINV (probability)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Probability | A probability corresponding to the normal distribution. | Required |
Notes
If Probability is nonnumeric, NORMSINV returns the #VALUE! error value.
If Probability <= 0 or if Probability >= 1, NORMSINV returns the #NUM! error value.
Given a value for Probability, NORMSINV seeks that value z such that NORMSDIST (z) = probability. Hence, precision of NORMSINV depends on precision of NORMSDIST. NORMSINV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns the #N/A error value.
Example
advanced_excel_compatibility_functions.htm
Advertisements