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.
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).
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.
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.
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: