writer
5,435
edits
Changes
→Description
*<math>NORMSINV</math> using the iterating method to find the value of <math>x</math>.
*<math>NORMSINV</math> using the iterating method to find the value of <math>x</math>.
*Suppose the iteration has not converged after 100 searches, then the function gives the error result.
*Suppose the iteration has not converged after 100 searches, then the function gives the error result.
*In <math>NORMSINV(prob)</math>, where prob is the probability value of the standard normal cumulative distribution.
*In <math>NORMSINV(prob)</math>, where <math>prob</math> is the probability value of the Standard Normal Cumulative Distribution.
*This function will return the result as error when
*This function will return the result as error when
1.<math>prob</math> is non-numeric.
1.<math>prob</math> is non-numeric.