Excel Function : NORM.S.INV

Excel Function : NORM.S.INV

Category

Statistical

Description

Returns the inverse of the standard normal cumulative distribution

Microsoft Excel Reference Page

https://support.office.com/en-us/article/NORMSINV-function-d6d556b4-ab7f-49cd-b526-5a20918452b1

Syntax and Description of the NORM.S.INV Excel Function

to read the last two non empty cells in a row and add them to a list? I am trying to use the NORM.S.INV function in Excel to read the last two non empty cells in a row and add them to a list of values. How do I use the NORM.S.INV function to do this? Thank you! A: You should be able to accomplish this with a simple INDEX function: =INDEX(A1:A20,MATCH(TRUE,INDEX(A1:A20<>"",

About NORM.S.INV Excel Function

NORM.S.INV is an Excel function that returns the inverse of the standard normal cumulative distribution. The inverse of the standard normal cumulative distribution is the value that has a cumulative probability equal to a given value.