What Does the 2 Mean in a WPS Spreadsheets ROUND Formula?
Question details
The user wants to know what the final argument 2 does in the formula =ROUND(K43/(E43-G43)*100,2).

- 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.
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.
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.
Click the cell containing =ROUND(K43/(E43-G43)*100,2) so it appears in the formula bar.
In the formula bar, find the comma after the calculation; the 2 is the num_digits argument.
Press Enter or click away to confirm. The cell shows the calculated value rounded to two decimal places.

Change Only the Displayed Decimal Places with Format Cells
Use this when you want to keep the full underlying value but display two decimal places.
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. Open WPS Office Spreadsheets: Launch WPS Office and open the workbook that contains the formula or a new spreadsheet.
- 2. Select the result cell: Click the cell where the rounded result should appear.
- 3. Enter the ROUND formula: Type =ROUND(K43/(E43-G43)*100,2) and press Enter.
- 4. Check the rounded output: Confirm that the result appears with two decimal places and the formula bar keeps the full ROUND formula.

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.




