How to Use the NORM.S.INV Function in WPS on Windows

Last updated:July 20, 2026

Use NORM.S.INV through 4 how-to topics, with 4 available without membership and 0 membership-related items.

How-to Index

No.TopicMembership Requirement
11. Enter the NORM.S.INV functionFree
22. View the function syntax promptFree
33. Use the function with cell referencesFree
44. Update results after data changesFree

How-to Guide

1. Enter the NORM.S.INV function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want the result to appear.
  2. Type = in the formula bar or directly in the cell.
  3. Type NORM.S.INV(.
  4. Enter the probability argument and close the parenthesis.
  5. Press Enter to show the result in the current cell.

Success Criteria

  • The cell displays a calculated result.
  • You can continue editing, copying, or filling the formula.

Tips While Using

  • If you do not start with =, the entry may be treated as plain text.
  • The argument must match the function requirement, or the result may return an error.

2. View the function syntax prompt

Entry point: formula bar

  1. Select an editable cell.
  2. Type =NORM.S.INV(.
  3. Watch for the syntax prompt that appears while you type.
  4. Use the prompt to confirm the parameter format before finishing the formula.

Success Criteria

  • The formula area shows the function name and parameter hint.
  • You can continue entering the argument and complete the formula.

Tips While Using

  • If the function name is misspelled, the matching prompt may not appear.

3. Use the function with cell references

Entry point: Formulas tab → formula bar

  1. Enter the probability value in a worksheet cell.
  2. Select the result cell and type =NORM.S.INV(.
  3. Click the cell that contains the probability value, or type the cell reference manually.
  4. Type the closing parenthesis and press Enter.
  5. If needed, combine the formula with other functions or cross-sheet references.

Success Criteria

  • The formula bar shows NORM.S.INV with a cell reference.
  • Changing the referenced value updates the result workflow.

Tips While Using

  • Referencing text-formatted data can cause unexpected results.
  • For cross-sheet references, confirm the sheet name and reference position.

4. Update results after data changes

Entry point: a cell that already contains the formula

  1. Locate the result cell that uses NORM.S.INV.
  2. Change the formula argument or edit the referenced source cell.
  3. Check whether the result recalculates automatically.
  4. If needed, review the reference range and formula structure again.

Success Criteria

  • The result changes when the input value changes.
  • You can continue analysis, copy the formula, or save the file.

Tips While Using

  • Incorrect references can make the updated result look wrong.