The rounding formula is as follows:

1. Inte rounding

For positive numbers, the decimal number is truncated to round. =INT(12.6), the result is 12; For negative numbers, cut off the decimal number, then -1, and round =INT(-12.6), and the result is -13.

2. TRUNC rounding

For both positive and negative numbers, rounding is done by truncating decimals. =TRUNC(12.6) the result is 12; =TRUNC(-12.6) The result is -12.

3. ROUNDing

when the second parameter of the round function is , rounding can be completed. Equal to ROUND(12.4) and the result is 12; Equal to ROUND(12.6) and the result is 13.

4. ROUNDing integer bits

When the second parameter of the Round function is negative, rounding integer bits can be completed =ROUND(1534.56,-1) and the result is 153; =ROUND(1534.56,-2) the result is 15; =ROUND(1534.56,-3) The result is 2.

Extended information:

EXCEL table processing software is an important member of OFFICE automation software developed by Microsoft Corporation of the United States. After many improvements and upgrades, the latest version is EXCEL2.

It can make all kinds of spreadsheets conveniently, and use formulas and functions to perform complex operations on data. Using various charts to represent data is intuitive and clear; Using hyperlink function, users can quickly open files on local area network or Internet, and share workbook files with Internet users anywhere in the world.

EXCEL provides many very large blank worksheets, each worksheet consists of 256 columns and 65536 rows, and the intersections of rows and columns form cells. Don't underestimate that the display of cells on the screen is not very large, and each cell can hold 32, characters.