NORMINV in WPS on Windows FAQ

Q: What should I do if NORMINV shows an error after I enter it?

Check whether the formula starts with = . Check whether the parentheses are paired correctly and whether all required parameters are included. Confirm that the parameter separators are correct. If you use cell references, check whether the referenced cells contain valid calculation data.

Q: How do I view the parameter hint for NORMINV?

Select the target cell. Type =NORMINV( . Look at the syntax hint shown in the formula editing area. Follow the hint to enter the parameters in order.

When using NORMINV, common questions usually involve formula entry, parameter input, and result checking; this FAQ includes 3 common questions and a short glossary.

FAQ

What should I do if NORMINV shows an error after I enter it?

Check whether the formula starts with =.
Check whether the parentheses are paired correctly and whether all required parameters are included.
Confirm that the parameter separators are correct.
If you use cell references, check whether the referenced cells contain valid calculation data.

How do I view the parameter hint for NORMINV?

Select the target cell.
Type =NORMINV(.
Look at the syntax hint shown in the formula editing area.
Follow the hint to enter the parameters in order.

Why does the result not change after I edit the data?

Check whether the formula references the correct cells.
Confirm that you changed a parameter cell that is actually used by the formula.
Select the result cell again and review whether the formula is complete.
If needed, re-enter the formula to verify the calculation.

Glossary

Term	Definition
NORMINV	An inverse normal distribution function that returns a result from a given probability, mean, and standard deviation.
Formula bar	The area in a spreadsheet where you enter and edit formulas.
Cell reference	A way to use a cell address as a parameter in a formula.