Home  >  Article  >  Software Tutorial  >  How to round numbers in Microsoft Excel How to round numbers in Microsoft Excel

How to round numbers in Microsoft Excel How to round numbers in Microsoft Excel

WBOY
WBOYOriginal
2024-06-03 15:05:131002browse

Want to extract the integer part from a number in Microsoft Excel? Do you know how to do it? PHP editor Xigua brings this tutorial to introduce in detail two methods to solve this problem, namely using ROUND and INT functions. Through this tutorial, you can easily master the skills of rounding numbers in Excel, making your data processing more convenient and efficient.

1. First open Microsoft Excel, and then enter some numbers, as shown in the figure below.

Microsoft Excel数字怎么取整数 Microsoft Excel数字取整数的方法

2. After that, you can click [Insert Function] in the upper left corner, as shown in the figure below.

Microsoft Excel数字怎么取整数 Microsoft Excel数字取整数的方法

3. Enter [round] in the search bar and select [round], as shown in the figure below.

Microsoft Excel数字怎么取整数 Microsoft Excel数字取整数的方法

4. Enter 0 in [Num_digits] in the function parameter menu and click OK, as shown in the figure below.

Microsoft Excel数字怎么取整数 Microsoft Excel数字取整数的方法

The above is the detailed content of How to round numbers in Microsoft Excel How to round numbers in Microsoft Excel. 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