The round function is a basic function in Excel, which is used to round the value by a specified number of digits, and the syntax is round(number,num digits). This value is rounded to the specified number of decimal places. In addition to numeric values, dates can also be rounded.
round function:
If num digits are greater than 0 (zero), the digits are rounded to the specified decimal place.
If num digits equals 0, the digits are rounded to the nearest integer. If num digits are less than 0, they are rounded to the first few decimal places.
To round up (away from 0), use the roundup function.
To round down (towards 0), use the rounddown function.
The following is a brief introduction to the usage of round correlation functions with examples.
Excel rounders are divided into rounding up, rounding down, and rounding.
round function, is a rounding function, parameter 2 input 0 is to remove the decimal place, the integer is the value after rounding, specific operation: enter the formula in cell C4: =round(B4,0), then select cell C4, double-click the fill handle in the lower right corner to fill in the formula downward, as shown in the following figure:
As shown in the image above: the round function rounds the numbers and then rounds them to an integer.
This function is a function that rounds the data up according to the specified number of decimal places, note that it is not rounded, because even if it is less than 4, it is necessary to take the value upwards, and there are still 2 parameters of this function: numeric value, number of decimal places, the following example to illustrate to you.
Example: Take the following data up to the specified number of decimal places.
Enter the formula:
Result after filling:
You can compare the results of the round function in the previous example.
The function of rounding down the value according to the specified number of decimal places is not rounded, because the value is taken down even if it is greater than 5.
Example] The following data is taken down by the specified number of decimal places.
This function also has 2 parameters: a numeric value and the number of decimal places, and the input formula:
Fill in the formula to get the final result:
Again, you can compare it with the round function and the roundup function mentioned above.
I hope the above content will be of substantial help to your work, if you don't understand anything, you can leave a message in the comment area. I also hope to give a like, give encouragement and support, and will continue to write more high-quality excel skills tutorials.
Which formula is used in Excel to calculate date days? Six ways to help you.
Does the sumsum function still only use the sum function? The dsum function is no1
Cell settings " " button, can you also select all at one point, will you?