WPS Features
Resources
Free AI Tools
Docs Center

How to Use the ROUND Function in WPS on Windows

Last updated:July 13, 2026

This how-to guide includes 3 topics for using ROUND, including entering it through Insert Function, typing the formula directly, and reviewing syntax details; 3 items are free and 0 items are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter ROUND through the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review syntax and argument detailsFree

How-to Guide

1. Enter ROUND through the Insert Function dialog box

Entry: 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 ROUND in the dialog box.
  4. Select the function and click OK.
  5. Enter each argument in the Function Arguments dialog box.
  6. Click OK to finish entering the function.

Success Criteria

  • The current cell contains a ROUND function.
  • A calculation result appears after the arguments are entered.
  • The formula can still be edited or copied to other cells.

Tips While Using

  • Search with the standard function name ROUND.
  • Use commas as argument separators.

2. Type the formula directly in a cell

Entry: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =ROUND(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, continue entering arguments after =ROUND( to complete the formula.

Success Criteria

  • The cell shows the ROUND calculation result.
  • The full formula is visible in the formula bar.
  • The formula can be filled down or copied to other cells.

Tips While Using

  • Make sure referenced cells contain numeric values instead of text.
  • When num_digits is negative, rounding is applied to digits to the left of the decimal point.

3. Review syntax and argument details

Entry: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Search for ROUND.
  3. Select the function and review the syntax ROUND(number, num_digits).
  4. Review the argument details, then complete the formula entry.

Success Criteria

  • The standard ROUND syntax is visible.
  • The roles of number and num_digits are clear.
  • You can continue entering the formula with the argument details in mind.

Tips While Using

  • If the result is not what you expect, check whether the digit argument is correct.
  • Before copying the formula, review relative and absolute references.