How to Use the NORMSINV Function in WPS on Windows

This how-to guide includes 4 topics for using NORMSINV in WPS Spreadsheet on Windows, and all 4 topics are available without membership.

How-to Index

How-to Guide

1. Enter the NORMSINV function

Entry point: Formula tab → formula bar, or enter the formula directly in the target cell

1. Open WPS Spreadsheet and select the cell where you want to show the result.
2. Type = to start the formula.
3. Type NORMSINV(.
4. Enter a valid probability argument and close the parenthesis.
5. Press Enter to confirm the formula.

Success Criteria

• Interface result: The cell displays a calculated result.
• Next action available: You can copy the formula, edit the argument, or fill it down to other cells.

Tips While Using

• Common mistake: If you do not start with =, the content is treated as plain text.
• Environment note: The argument should be a valid probability value.

2. View the function syntax prompt

Entry point: Formula tab → formula bar

1. Select any blank cell.
2. Type =NORMSINV(.
3. Watch for the syntax prompt in the editing area.
4. Complete the argument based on the prompt.

Success Criteria

• Interface result: A parameter prompt appears after you type the function name.
• Next action available: You can continue entering the formula with the prompt as a reference.

Tips While Using

• Common mistake: If the function name is misspelled, the correct prompt may not appear.

3. Use a cross-sheet reference

Entry point: Formula tab → formula bar

1. Select the result cell in the current worksheet.
2. Type =NORMSINV(.
3. Switch to another worksheet that contains the probability value and select the target cell.
4. Close the parenthesis and press Enter.

Success Criteria

• Interface result: The formula includes a cross-sheet reference and returns a result.
• Next action available: When the referenced cell changes, the result updates accordingly.

Tips While Using

• Common mistake: If the referenced cell does not contain a valid probability value, the formula may return an error.

4. Create a nested formula with automatic recalculation

Entry point: Formula tab → formula bar

1. Select the cell where you want the result.
2. Enter a combined formula that includes NORMSINV.
3. Press Enter to confirm the formula.
4. Change related input data and check whether the result updates automatically.
5. If needed, press F9 to recalculate.

Success Criteria

• Interface result: The nested formula returns a result, and related changes update the output.
• Next action available: You can continue editing either the outer or inner formula.

Tips While Using

• Common mistake: If the number of parentheses does not match, the formula cannot calculate correctly.