ROUND, ROUNDUP and ROUNDOWN

The ROUND function rounds a number to a specified number of digits. For example, if you have 25.4568 in cell A1 and you want to round the figure to two decimal places, when you use the formula =ROUND(A1, 2), it will return 25.46.

ROUNDUP and ROUNDOWN are similar to ROUND but as their name suggests, they round numbers in a specific direction. ROUNDUP always rounds a number up, away from zero while ROUNDOWN always rounds a number down, towards zero.

Syntax

ROUND(number, num_digits)

ROUNDUP(number, num_digits)

ROUNDDOWN(number, num_digits)

Arguments

Argument	Description
number	Required. This argument is the number that you want to round.
num_digits	Required. This is the number of decimal places to which you want to round the number.

A couple of points to take into consideration when using these three functions:

• If num_digits is greater than zero (that is the number of decimal places to which you want to round the number), then the number is rounded to the specified number of decimal places.
• If num_digits is 0 (zero), then the number is rounded to the nearest integer.
• If num_digits is less than 0 (zero), then the number is rounded to the left of the decimal point.
• Use the ROUNDUP function if you want to always round up (away from zero).
• Use the ROUNDDOWN function if you want to always round down (toward zero).

Examples

In the following examples, ROUND, ROUNDUP and ROUNDOWN are applied to different values to show the output. The tables below display the formula, the result, and a description of the result.

Formula	Result	Description
=ROUND(3.15, 1)	3.2	Rounds 3.15 to one decimal place.
=ROUND(4.149, 1)	4.1	Rounds 4.149 to one decimal place.
=ROUND(-2.475, 2)	-2.48	Rounds - 2.475 to two decimal places.
=ROUND(57.5, -1)	60	Rounds 57.5 to one decimal place to the left of the decimal point.
=ROUND(671.3,-3)	1000	Rounds 671.3 to the nearest multiple of 1000.
=ROUND(1.78,-1)	0	Rounds 1.78 to the nearest multiple of 10.
=ROUND(-70.45,-2)	-100	Rounds -70.45 to the nearest multiple of 100.