Home >Topics >excel >How to retain 2 decimal places in round function

How to retain 2 decimal places in round function

藏色散人
藏色散人Original
2020-05-31 13:33:4330999browse

How to retain 2 decimal places in round function

How does the round function retain 2 decimal places?

Open the table and click the formula button, as shown in the figure

Recommended: "Excel Tutorial"

How to retain 2 decimal places in round function

Click to insert a function, as shown in the figure

How to retain 2 decimal places in round function

Select Mathematics and Trigonometric Functions, as shown in the figure

How to retain 2 decimal places in round function

In Mathematics Select the ROUND function from Trigonometric Functions, as shown in the figure

How to retain 2 decimal places in round function

Input the numerical range and the number of decimal places to be retained in the pop-up dialog box, and click the OK button, as shown in the figure

How to retain 2 decimal places in round function

Return the value with two decimal places, as shown in the figure

How to retain 2 decimal places in round function

The above is the detailed content of How to retain 2 decimal places in round function. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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