Menu
EXCEL NORM.S.INV FUNCTION
Excel NORM.S.INV Function Introduction
For a given probability value, the Excel NORMSINV function computes the inverse of the Standard Normal Cumulative Distribution Function.
Description of Excel NORM.S.INV Function
Syntax :
=NORMSINV( probability )
Parameters :
- The given probability is the probability value (between 0 and 1) at which the inverse of the standard normal cumulative distribution function should be calculated.
Step By Step Guide of NORM.S.INV Function
Example :
The Excel Normsinv Function is used in the spreadsheet below to calculate the inverse of the Standard Normal Cumulative Distribution Function for three distinct probability values.
The formulae are shown on the left spreadsheet, while the results are given on the right spreadsheet.
Key Points
- #NUM! – Occurs if the likelihood argument given is 0 or 1.
- #VALUE! – Occurs if the provided probability argument is not a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
