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
| # | Topic | Membership |
|---|---|---|
| 1 | 1. Enter the PERMUT function | Free |
| 2 | 2. View function syntax prompts | Free |
| 3 | 3. Use cross-worksheet references | Free |
| 4 | 4. Build nested calculations and automatic recalculation | Free |
How-to Guide
1. Enter the PERMUT function
Entry point: Formulas tab → formula bar
- Open WPS AirSheet and select the cell where you want to show the result.
- Type
=to start editing a formula. - Type
PERMUT(. - Enter the two arguments, such as
PERMUT(5,3). - 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
- Select any blank cell.
- Type
=PERMUT(. - Check the syntax prompt shown in the editing area.
- 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
- In the result cell, type
=PERMUT(. - Switch to another worksheet that contains the parameter data.
- Select the cell for the first argument and enter the separator.
- Select the cell for the second argument.
- 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
- Select the target cell and enter a combined formula.
- Nest
PERMUTwith other functions or reference expressions in the formula. - Press Enter to finish input.
- Change the source data used in the calculation.
- 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.