What is the excel rounding function?

Rounding function ROUND:

Function format: ROUND (numeric value or numerical cell, number of digits to be retained)

The usage method is as follows:

Example:

Enter the formula =ROUND(A1,0) in cell B1 and press Enter. 85.54 in cell A1 becomes 86, and the result is rounded; change the value of A1 to 85.4, and then use the formula =ROUND(A1,0), the result is 85, without rounding; then change the value of cell A1 to -85.6, also use the formula =ROUND(A1,0), the result is -86, which is also one step forward; the steps of the operation process are as follows:

##Note: When entering a comma, be sure to enter

in the English input method. For more Excel-related technical articles, please visit the

Excel Basic Tutorial column!

The above is the detailed content of What is the excel rounding function?. For more information, please follow other related articles on the PHP Chinese website!