The ROUND FUNCTION is very useful function in day to day report making.
Many times we come across the calculations which doesn’t conclude in a number with fixed decimal portion. To get rid of this, we always round the number to a fixed number of decimals.
For example, if we want to round a number upto 2 decimals ,
12.345 will be rounded to 12.35,
11.321 will be rounded to 11.32 and so on.
The ROUND FUNCTION comes under the MATH and TRIG functions in Microsoft Excel.
THE ROUND FUNCTION ROUNDS ANY NUMBER UP TO THE SPECIFIED NUMBER OF DIGITS.
In this article, we will learn about the purpose, syntax formula, example and other information about the ROUND FUNCTION in Excel.
ROUND FUNCTION simply rounds the number to a specified number of digits.
The function is simple yet very powerful and useful.
Suppose, we have the following numbers.
100.234324, 23.343 , 234
and we want to round them up to 2 digits after decimal.
The result will be
100.23, 23.34 , 234.00
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
The Syntax for the ROUND function is
ROUND ( NUMBER, NUMBER OF DIGITS UP TO WHICH YOU WANT TO ROUND )
NUMBER is the given number.
NUMBER OF DIGITS UP TO WHICH YOU WANT TO ROUND can be chosen as per the requirement such as 2 ,4 or any number.
The number of digits up to which we can round [ second argument ] can be zero, negative or positive.
In the examples, we’ll see the effect of all the three situations.
Let us take a group of various numbers.
The following table shows the different numbers which are to be rounded separately according to different situations as per the instructions.
Now, let us try to understand the various examples discussed and the reason behind the usage of such formula.
We’ll discuss the number of digits up to which the number needs to be rounded i.e. the second argument only as the first argument is the number which is to be rounded and is quite easy to understand.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE