Free All-in-One Office Suite with PDF Editor

Edit Word, Excel, and PPT for FREE.

Read, edit, and convert PDFs with the powerful PDF toolkit.

Microsoft-like interface, easy to use.

Windows • MacOS • Linux • iOS • Android

# Use the ROUND function to round decimals quickly

Uploaded time: August 27, 2021 Difficulty Intermediate

# Use the ROUND function to round decimals quickly

Use the ROUND function to round decimals quickly

In our work and study, we often have to round off decimals. Let me show you how to use the ROUND function to deal with long strings of decimals quickly.

Take the decimal in the **B3** cell as an example.

1. Place the cursor in **C3**.

2. Click **Insert Function**.

3. In **Math and Trig**, select the **ROUND** function.

The pop-up dialog box has two parameters. **Number** is the numerical value to be rounded, and **Num_digits** refers to the digits to be used for rounding.

If the **Num_digits** is greater than 0, then the number will be rounded to the specified number of Num_digits. If the **Num_digits** equals 0, then the number will be rounded to the nearest integer. If the **Num_digits** is less than 0, the number will be rounded to the corresponding digit to the left of the decimal point.

In the **Number** in the selection of the **B3** cell, because we want to round to four decimal places, we enter **4** in the **Num_digits**, and click **OK**.

Select the **C5** cell, insert the ROUND function. Because we want to round to the whole number, enter **0** in **Num_digits** and click **OK** finally.Select the **C7** cell, insert the ROUND function. Because we want to round to the second place to the left of the decimal point, we enter **-2**, and then click **OK**.

So in practical work, how can we use the ROUND function?

Take this payroll as an example. We need to round the after-tax income to two decimal places.

1. Weneed to select the **G3** cell and insert the ROUND function.

2. Enter **F3** and **2** for **Number** and **Num_digits**, respectively.

3. Click **OK**.

What a fast and quick function! Easy your work with WPS Spreadsheet like Microsoft Excel. Did you get it?

Also Read:

- 1. The SUMPRODUCT function for quick calculation of total sales
- 2. Combine the SUBSTITUTE and LEN functions
- 3. COUNTIFS function: count data of multiple criteria
- 4. Use the Today function to quickly calculate days between dates
- 5. Use the cross-reference function to quickly jump
- 6. Use SUM function to quickly calculate the sum

Does this video help you?