The formulas for rounding numbers in Excel mainly include the following:
In the process of Excel data processing, numerical rounding is relatively common, and we need to use different rounding methods for different requirements. function to solve. So today the gang leader will share with you 7 ways of rounding values, please save them for later use!
1
INT function rounding
INT should be the most familiar function for numerical rounding, and it is also very simple to operate. As shown in the following animation:
We can see that the value is a positive number, and the decimal is removed and rounded directly. If the value is a negative number, it needs to be rounded to -1 after removing the decimal.
2
TRUNC function rounding
Use the TRUNC function to round numeric values. The rules are simple. Regardless of whether the value is a positive or negative number, remove the decimal and then round directly. No carry.
3
ROUND function rounding
ROUND function rounding follows the rounding principle. The first parameter in the function formula is a numerical value, and the second parameter is Represents a number of decimal places. If the second parameter is positive, the decimal part is rounded, if negative, the integer part is rounded. As shown in the following animation:
4
ROUNDUP function rounding
The meaning of the parameters of the ROUNDUP function formula is the same as that of the ROUND function. According to the second parameter, it will be discarded. Specify the number of digits and "round up" by one. If the value is an integer, it will remain unchanged after rounding. As shown in the following animation:
5
ROUNDOWN function rounding
The meaning of the ROUNDOWN function formula parameters is also consistent with the ROUND function, and its effect is actually the same as TRUNC The function is the same, rounding off the specified number of digits based on the second argument but not carrying. As shown in the following animation:
6
CEILING function rounding
The first parameter in the CEILING function formula is a numerical value, and the second parameter is the specified base. , that is, the value is rounded up to the nearest integer or the nearest integer multiple of the specified base. As shown in the following animation:
We enter the formula in cell A2: =CELING(A2,5). The second parameter is 5. All values ??are rounded up to the integer closest to 5. times.
7
FLOOR function rounding
The FLOOR function parameters are consistent with the CEILING function and are used to round the value down to the nearest integer, or to the nearest integer. The nearest integer multiple of the specified base. As shown in the following animation:
We enter the formula in cell A2: =FLOOR(A2,3). The second parameter is 3. All values ??need to be rounded down to the nearest 3. Integer multiple.