NORM.S.INV(probability)

Returns the x variable corresponding to less than a particular probability.

probabilityThe probability associated with the distribution.

Remarks

* Added in Excel 2010.
* This function replaces the NORMSINV function.
* The standard normal distribution is a continuous distribution.
* mean 0, standard deviation 1
* For the Microsoft documentation refer to support.office.com

 A
1=NORM.S.INV(0.908789) = £1.33


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top