Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - What is the formula of function rounding? Introduction of function rounding formula
What is the formula of function rounding? Introduction of function rounding formula
1, INT function This function is relatively simple, that is, rounding off decimal places. The formula is "=INT(A3)". If the value is positive, only the integer part is removed. If the numerical value is negative, then-1 will be added after removing the decimal and taking the integer part.

2. Overview function. This function adopts the rounding method, that is, if there is a numerical value after rounding, enter 1, and if it is an integer, it will remain unchanged. The formula is "= roundup (a3 a3,0)", and the first parameter in parentheses is the value to be rounded. The second parameter is the rounding position, where "0" is the number of decimal places, the positive number is the number of decimal places, and the negative number is the number of decimal places.

3. Round down the function. This function gives way to rounding, that is, only the value before the rounding position is taken, and the value after it is discarded. The formula is "= rounddown (a3 a3,0)", and the first parameter in parentheses is the value to be rounded. The second parameter is the rounding position, where "0" is the number of decimal places, the positive number is the number of decimal places, and the negative number is the number of decimal places.

4. Circular function. This function is rounded. The formula is "= round (a3 a3,0)", and the first parameter in brackets is the value to be rounded. The second parameter is the rounding position, where "0" is the number of decimal places, the positive number is the number of decimal places, and the negative number is the number of decimal places.

5.TRUNC function. For a function, only integers are taken, and the effect is the same as that of the ROUNDDOWN function. The formula is "= trunc (a3 a3,0)", and the first parameter in brackets is the value to be rounded. The second parameter is the rounding position, where "0" is the number of decimal places, the positive number is the number of decimal places, and the negative number is the number of decimal places.