The method of using the round function in excel is: first open the excel table, select the cells that need to be operated; then enter the formula "=ROUND (data to be calculated, number of digits to be retained)" in the cell ;Finally press the "Enter" key on the keyboard to get the result.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
The steps to use the ROUND function in EXCEL are as follows:
Open Excel, select the cell, and enter the data to be calculated.
Select the cell of the calculation result, as shown in the figure.
Enter "=ROUND (D10, 2)" in the cell and press Enter to confirm. Among them, D10 refers to column D, row 10, and 2 means keeping two decimal places.
The result is the rounded result, as shown in the figure.
Extended information:
Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The intuitive interface, excellent calculation functions and charting tools, coupled with successful marketing, make Excel the most popular personal computer data processing software. In 1993, after version 5.0 was released as a component of Microsoft Office, Excel began to become the dominant spreadsheet software on applicable operating platforms.
The Round function returns a value that is the result of rounding to the specified number of decimal places. But when the reserved bit is followed by 5, it may be carried or discarded, and the chances are 50% each. This can cause calculation errors in the application.
Related learning recommendations:excel tutorial
The above is the detailed content of How to use round function in excel. For more information, please follow other related articles on the PHP Chinese website!