Function Problems

What Does the 2 Mean in a WPS Spreadsheets ROUND Formula?

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 869 views

Question details

The user wants to know what the final argument 2 does in the formula =ROUND(K43/(E43-G43)*100,2).

What Does the 2 Mean in a WPS Spreadsheets ROUND Formula?
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
The user is working with a spreadsheet formula and needs to interpret the ROUND function's second argument.
Observed behavior
The formula includes a final 2 after the comma, and the user is unsure how it affects the calculated result.
Before you start

Open the workbook in WPS Office Spreadsheets and select the cell that contains the ROUND formula; then look at the formula bar to see the formula's arguments.

Solution 1Recommended

Understand the 2 as the Number of Decimal Places in ROUND

Use this explanation when you want the formula result rounded to two decimal places in the cell's stored value.

In the ROUND function, the second argument is num_digits. A positive value rounds the result to that many digits to the right of the decimal point. Therefore, 2 rounds the underlying value to two decimal places, such as 12.345 to 12.35.

1
Select the formula cell

Click the cell containing =ROUND(K43/(E43-G43)*100,2) so it appears in the formula bar.

2
Locate the second argument

In the formula bar, find the comma after the calculation; the 2 is the num_digits argument.

3
Read the rounded result

Press Enter or click away to confirm. The cell shows the calculated value rounded to two decimal places.

Understand the 2 as the Number of Decimal Places in ROUND
Rounded value is stored: ROUND(...,2) changes the stored cell value to two decimal places, unlike number formatting, which only changes the display.

Use the ROUND Function with Two Decimal Places in WPS Office Spreadsheets

WPS Office Spreadsheets uses the same ROUND function syntax as Excel, so you can apply =ROUND(K43/(E43-G43)*100,2) directly and keep your formulas compatible with Microsoft Excel workbooks.

  1. 1. Open WPS Office Spreadsheets: Launch WPS Office and open the workbook that contains the formula or a new spreadsheet.
  2. 2. Select the result cell: Click the cell where the rounded result should appear.
  3. 3. Enter the ROUND formula: Type =ROUND(K43/(E43-G43)*100,2) and press Enter.
  4. 4. Check the rounded output: Confirm that the result appears with two decimal places and the formula bar keeps the full ROUND formula.
Uses the same ROUND syntax as Microsoft Excel, so existing formulas work without rewriting.Supports .xlsx and other Microsoft Office file formats for smooth sharing and migration.Free alternative with a familiar spreadsheet interface and low system resource usage.Returns a two-decimal rounded value while preserving formula logic in WPS Office.
microsoft office alternative - wps office

Frequently Asked Questions

Does ROUND(...,2) change the stored value or only the display?

It changes the stored value to exactly two decimal places. Cell formatting can make a value look rounded, but the underlying value remains unchanged.

What happens if I use 0 instead of 2 in ROUND?

The ROUND function rounds to 0 decimal places, returning a whole number. Negative values round to the left of the decimal point, such as -1 for tens.

Where is the ROUND function located in WPS Office Spreadsheets?

Click the Formulas tab, open Math & Trig or Insert Function, search for ROUND, and fill in the number and num_digits fields; you can also type the formula directly.

Can I round up or down instead of standard rounding?

Yes. Use ROUNDUP to always round away from zero and ROUNDDOWN to always round toward zero, with the same num_digits argument such as 2.