WPS Features
Resources
Free AI Tools
Docs Center

How to Use the NORMSINV Function in WPS on Windows

Last updated:July 13, 2026

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

How-to Index

No.TopicMembership Requirement
11. Enter the function through the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review syntax and parameter detailsFree

How-to Guide

1. Enter the function through the Insert Function dialog

Entry point: Formula tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for NORMSINV in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameter in the Function Arguments dialog.
  6. Click OK to insert the formula.

Success Criteria

  • The selected cell now contains the NORMSINV function.
  • A calculation result is returned after the parameter is entered.
  • The formula can be edited, copied, or filled into other cells.

Tips While Using

  • The parameter should be a valid probability value.
  • Avoid extra spaces or nonstandard punctuation in the input.
  • If the result looks incorrect, reopen the dialog and review the parameter.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the target cell.
  2. Type =NORMSINV(...) in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, drag the fill handle or copy the formula to other cells.

Success Criteria

  • The cell shows a calculated result instead of plain text.
  • The full formula is visible in the formula bar when the cell is selected.
  • The formula can be reused in other worksheet areas.

Tips While Using

  • The function name must start with an equals sign.
  • Use a standard comma as the parameter separator.
  • When filling across multiple cells, check relative and absolute references.

3. Review syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Search for NORMSINV.
  3. Select the function to review its syntax and parameter details.
  4. If needed, compare the guidance with your current input before confirming the formula.

Success Criteria

  • The NORMSINV function name and parameter area are visible.
  • You can use the guidance to confirm whether the parameter is entered correctly.
  • You can return to the worksheet and continue editing the formula.

Tips While Using

  • Syntax review is useful before entering the final formula.
  • If an existing formula returns an error, compare it with the displayed guidance step by step.