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