Excel Round Function

This tutorial explains how to use Excel Round Function

Excel Round Function

There are several kinds of Rounding in Excel – Round, Round up, Round down, Mround,  plus Banker’s Rounding in VBA.

Excel Round Function is the most commonly used round, it uses “round half to up” logic, round up if the decimal part >=0.5, round down if decimal part <0.5

Syntax of Excel Round Function

ROUND( number, digits )
number The number you want to apply rounding
digits An integer that indicate the digit you want to round, can be positive or negative

Example of Excel Round Function

Number Formula Result
0.1 =ROUND(A2,0) 0
0.2 =ROUND(A3,0) 0
0.3 =ROUND(A4,0) 0
0.4 =ROUND(A5,0) 0
0.5 =ROUND(A6,0) 1
0.6 =ROUND(A7,0) 1
0.7 =ROUND(A8,0) 1
0.8 =ROUND(A9,0) 1
0.9 =ROUND(A10,0) 1
1 =ROUND(A11,0) 1
-1.1 =ROUND(A12,0) -1
-1.2 =ROUND(A13,0) -1
-1.3 =ROUND(A14,0) -1
-1.4 =ROUND(A15,0) -1
-1.5 =ROUND(A16,0) -2
-1.6 =ROUND(A17,0) -2

Outbound References

http://www.techonthenet.com/excel/formulas/round.php

Wyman W
Wyman is a Human Resources professional based in Hong Kong, specialized in business analysis, project management, data transformation with Access and Excel.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist in Access / Excel
- Microsoft Specialist in MS Project
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *