The return value is a z-score, which represents how far the value is from the mean of the distribution in terms of the standard deviation. See NORM.INV for non-standardized input. Probability input outside of the range of (0,1) results in an error.  The standard normal distribution is a special case of the normal distribution with a mean of 0 and a standard deviation of 1. The standard normal cumulative distribution function returns the probability of an event occurring below a threshold value. This probability is equal to the area under the bell-shaped curve to the left of the threshold value.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.