Math and trigonometry
ROUND Function
Rounds a number to a specified number of digits
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
The Father of Spreadsheet Dashboard Reports

Syntax
ROUND(number,num_digits)
 number Required. The number to be rounded.
 num_digits Required. The number of
digits to round the number argument.
 If num_digits is greater than 0 (zero), then number is
rounded to the specified number of decimal places. (See
examples 1 & 2 below.)
 If num_digits is 0, the number is rounded to the nearest
integer. (See examples 3 & 4 below.)
 If num_digits is less than 0, the number is rounded to
the left of the decimal point. (See examples 5 through 8
below.)
Applies To
Excel 2003 and above
A Note About
"Rounding"
In Excel, numbers can "round" in two ways.
First, they can round up or down. With this type of rounding,
numbers
get larger when they are rounded up, and smaller when they are
rounded down.
Second, numbers can round towards zero or away from zero.
When positive numbers are rounded towards zero, they get
smaller; when negative numbers are rounded towards zero, they get larger.
Although Microsoft uses "round up" and "round down" to
describe both types of rounding, we use "round up" or "round
down" to describe the first type of rounding. And we use "round
towards zero" or "round away from zero" to describe the second
type.
Remarks
 Use the ROUNDUP
function to always round up (away from zero).
 Use the ROUNDDOWN
function to always round down (toward zero).
 Use the MROUND
function to round a number to a specific multiple (for
example, to round to the nearest 0.2).
Examples
You can
download this example workbook here,
along with all other example workbooks I've completed for this
Excel help area.
Other Help
Related Functions
In total,
Excel 2013 offers 15 functions that round data in
various ways. Here's a
summary of Excel's rounding functions.
