How to Use the PERMUT Function in WPS on Windows

Last updated:July 17, 2026

Use PERMUT with 4 how-to topics, all available directly in WPS AirSheet; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Enter the PERMUT function

Entry point: Formulas tab → formula bar

  1. Open WPS AirSheet and select the cell where you want to show the result.
  2. Type = to start editing a formula.
  3. Type PERMUT(.
  4. Enter the two arguments, such as PERMUT(5,3).
  5. Press Enter to confirm, and the result appears in the current cell.

Success Criteria

  • UI state: The target cell shows the permutation result.
  • Next actions: You can copy the formula, edit the arguments, or reference other cells.

Tips While Using

  • Common mistakes: If the formula does not start with =, the content is treated as plain text.
  • Environment limits: The arguments should meet the function requirements to avoid errors.

2. View function syntax prompts

Entry point: formula bar

  1. Select any blank cell.
  2. Type =PERMUT(.
  3. Check the syntax prompt shown in the editing area.
  4. Complete the arguments based on the prompt and finish the formula.

Success Criteria

  • UI state: A parameter prompt appears after you type the function name.
  • Next actions: You can continue entering arguments and complete the calculation.

Tips While Using

  • Common mistakes: If the function name is misspelled, the correct prompt will not appear.

3. Use cross-worksheet references

Entry point: formula bar

  1. In the result cell, type =PERMUT(.
  2. Switch to another worksheet that contains the parameter data.
  3. Select the cell for the first argument and enter the separator.
  4. Select the cell for the second argument.
  5. Complete the closing parenthesis and press Enter.

Success Criteria

  • UI state: The formula shows cross-worksheet reference addresses.
  • Next actions: When source worksheet data changes, the result updates accordingly.

Tips While Using

  • Common mistakes: Referencing a text cell may cause an error result.

4. Build nested calculations and automatic recalculation

Entry point: formula bar

  1. Select the target cell and enter a combined formula.
  2. Nest PERMUT with other functions or reference expressions in the formula.
  3. Press Enter to finish input.
  4. Change the source data used in the calculation.
  5. Check whether the result updates automatically.

Success Criteria

  • UI state: The combined formula returns a result, and the result updates when source data changes.
  • Next actions: You can extend the formula into more complex statistical analysis.

Tips While Using

  • Common mistakes: Unmatched parentheses can prevent the formula from calculating correctly.
  • Environment limits: For complex formulas, review the structure in the formula bar before confirming.