Home > Topics > excel > body text

How to use excel round up function

藏色散人
Release: 2019-06-12 09:14:30
Original
39769 people have browsed it

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 the Excel Basic Tutorial column!

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!

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