WPS Features
Resources
Free AI Tools
Docs Center

How to Use the RANK Function in WPS on Windows

Last updated:July 13, 2026

Use the RANK function in WPS with 3 how-to topics, covering function insertion, direct formula entry, and syntax review; 3 are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert RANK from the Insert Function dialog boxFree
22. Type a RANK formula directly in a cellFree
33. Review RANK syntax and parameter detailsFree

How-to Guide

1. Insert RANK from the Insert Function dialog box

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 RANK in the dialog box.
  4. Select the function and click OK.
  5. Enter the required parameters in the Function Arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • The selected cell contains the RANK function.
  • The parameter dialog accepts input and returns a result.
  • The formula can be edited, copied, or filled down.

Tips While Using

  • Search with the English function name RANK.
  • Make sure the referenced range includes the numbers used for comparison.

2. Type a RANK formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the target cell.
  2. Type =RANK(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, review the syntax hint after typing =RANK(.

Success Criteria

  • The cell shows a ranking result or enters parameter input mode.
  • The full RANK formula is visible in the formula bar.
  • The result can be filled down to other cells.

Tips While Using

  • Separate parameters with English commas.
  • When copying the formula, check whether relative or absolute references are needed.

3. Review RANK syntax and parameter details

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Enter RANK in the search box.
  3. Select the function to review its syntax and parameter details.
  4. Open the related help entry if you need more guidance.

Success Criteria

  • You can see the function name, syntax, and parameter area.
  • You can confirm how each parameter should be entered.
  • You can return to the worksheet and continue editing.

Tips While Using

  • If the result is not what you expect, check the parameter order and referenced range first.
  • Online help pages require an internet connection.