Home>Article>Topics> How to use excel round up function

How to use excel round up function

藏色散人
藏色散人 Original
2019-06-12 09:14:30 39701browse

How to use excel round up function

Steps to use excel round up function:

1. First, select the cell where you want to insert the formula.

How to use excel round up function

#2. Enter the formula “=roundup” to complete the insertion of the function formula.

How to use excel round up function

#3. The ROUNDUP function needs to input two parameters. The first is to choose which integer you want to round up, and the second is to keep how many decimal places.

How to use excel round up function

#4. Select cell A2 for the first parameter, which means rounding up the value of A2.

How to use excel round up function

#5. After entering the comma, directly enter 0 in the second parameter, which means retaining 0 decimal places.

How to use excel round up function

#6. After pressing the enter key, you can get the result of rounding up cell A2.

How to use excel round up function

#7. Double-click the fill handle to complete the automatic filling of the following cells.

How to use excel round up function

For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn!

The above is the detailed content of How to use excel round up 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
Previous article:How to transpose excel Next article:How to transpose excel