Returns a number rounded to the specified number of digits.
Syntax
ROUND（number,num_digits）
Number The number that needs to be rounded.
Num_digits specifies the number of digits, press this digit Numbers are rounded.
Description
￭ If num_digits is greater than 0, it is rounded to the specified decimal place.
￭< /span> If num_digits equals 0, round to the nearest integer.
￭ < /span>If num_digits is less than 0, round to the left of the decimal point.
While working and studying We often have a headache about how to quickly round long series of decimals.
The following will teach you how to use the Round function of WPS 2019 EXCEL table to quickly calculate long series of decimals.
￭Open the form, take the decimal part of pi as an example, and place the cursor at (D3).
Click Insert Function-Mathematics and Trigonometric Functions-Round Function, there are two parameters in the pop-up dialog box.
"Number" is the value that needs to be rounded;
The number of decimal places is the number of digits used for rounding.
If the value to be rounded is a negative number, round to the left of the decimal point. If the value is 0, round to the nearest integer.
￭Enter (C3) pi in the "Number" field. Because we want to take seven decimal places, enter it in the "Decimal Places" field 7.
Click OK,to get the pi with only seven decimal places.
￭We put the cursor at (D5) to insert the Round function, and enter (C3) at the "numeric value". Because we want to take an integer, so in Enter 0 in "Decimal Place".
Click OK to get the integer closest to (C3) pi.
￭Similarly, place the cursor at (D7), insert the Round function, and enter the "numeric value" (C3).
Because we need to round the first digit to the left of the decimal point, so in the "decimal place" Enter -1.
Click OK to get the rounded value of (C3) pi.
Have you learned such a convenient and quick trick?
支付宝扫一扫 
评论列表（196条）
测试