What are the functions that retain integers in excel?

INT function rounds to integers. For positive numbers, the decimal part is directly removed and the integer is rounded. For negative numbers, the decimal part is cut off and the integer is obtained at -1.

#TRUNC function rounds, directly intercepts the decimal part and rounds it, the same goes for negative numbers.

#ROUND function, rounding method, when the second parameter is 0, it is rounded.

ROUND function, rounding the integer part, when the second parameter is a negative number, can complete the rounding on the corresponding integer digit.

Ceiling upward multiple rounding function, the first parameter is the value to be rounded up, and the second parameter is the multiple to be rounded.

Recommended tutorial: excel tutorial

The above is the detailed content of What are the functions that retain integers in excel?. For more information, please follow other related articles on the PHP Chinese website!