Home > Topics > excel > body text

How to use round function in excel

醉折花枝作酒筹
Release: 2023-01-13 00:42:32
Original
50939 people have browsed it

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.

How to use round function in excel

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.

How to use round function in excel

Select the cell of the calculation result, as shown in the figure.

How to use round function in excel

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.

How to use round function in excel

The result is the rounded result, as shown in the figure.

How to use round function in excel

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template