≡ Menu

How to use Round Function in Excel

In this tutorial I will teach you how to use Round Function in Excel 2013.

In Microsoft Excel 2013, Round function returns a number which is rounded to a specific number of digits like decimal points or nearest dollar.

This function is categorized as a Math/Trig Function under the formula Tab.

word-image

It can be used inside a formula or separately in a cell of the worksheet.

This can also be used inside VBA code which has a different syntax.

Syntax of the Round function is:

Round (number, num_digits).

Where:

Number: The value you will put in that you want to round off.

Num_digits:  The number of digits to which you want the number rounded. Entering the number 0 means that excel will round to the closest integer. Positive value of means that excel will round the number specific to the decimal places.

If a negative number is being entered, it will round the number left of the decimal point means that it will round to the nearest tenth, hundredth, thousandth etc.

word-image

There are different variants of Round function which are RoundUp and RoundDown.

Both ROUNDUP and ROUNDDOWN take same number of arguments (Number, num_digits).

The difference between ROUNDUP and ROUNDDOWN is:

Roundup function always rounds up to the specified value.

Rounddown function always rounds down to the specified value.

For example. A number 54678.7897 and we want to round to 2 decimal points.

If we use roundup function: =Roundup(54678.7897,2) the answer will be 54678.79

And if Rounddown function is used: =Rounddown(54678.7897,2) the answer would come up to be 54678.78.

Here is another example with different variation of Round, Roundup and RoundDown function.

word-image-56

In the first example, we used zero in the “Num_digits” argument which will round to the nearest whole number.

Num_digits argument 1,2 and 3 means that the number is rounded off to the first, second and third decimal places respectively.

Note the difference between ROUNDUP and ROUNDDOWN values with 2 as its num_digits argument.

For Roundup function, the value is 1234.57 while for Rounddown function, the value came up to be 1234.56.

You can also use negative num_digits argument. This will round the number to the nearest tenth, hundredth and thousandth.

For example the number 248,987 will be rounded off in the following way:

word-image-57

{ 0 comments… add one }

Leave a Comment