Friends,
While dealing with data analysis sometimes we need to
take only the integer part i.e., without the fraction from data i.e., rounded
data or upto two decimal numbers for currency and ease of understanding by human beings. One method to get the rounded data is that we just click on the decrease
decimal and we can see only the integer part but actually the decimal part or
the fraction is not deleted, it is hidden, to get the actual integer part we
need to use Microsoft Excel ROUND function.
Today we shall discuss about three functions ROUND, ROUNDUP & ROUNDDOWN. ROUND, ROUNDUP and ROUNDDOWN Function - Combination of VLOOKUP with ROUND
You can use this three function in nested conditions
i.e., with other function to create a compound formula. One example is given
below, it is ROUND function with VLOOKUP function.
How to use the ROUND Function
Description
The Microsoft Excel ROUND function returns a number
rounded to a specified number of digits.
The ROUND function is a built-in function in Excel
that is categorized as a Math/Trig Function. As a worksheet
function, the ROUND function can be entered as part of a formula in a cell of a
worksheet.
Syntax
The syntax for the ROUND function in Microsoft Excel
is
=ROUND(number, num_digits)
Parameters
or Arguments
number
The number to round.
num_digits
The number of digits to round the number to.
Example
Let's look at some Excel ROUND function examples and
explore how to use the ROUND function as a worksheet function in Microsoft
Excel:
From the syntax of ROUND function we can use this
function as =ROUND(C2,0) as shown in the below picture.
 |
| Round Function in Excel |
Use of ROUND with VLOOKUP
Use nested ROUND function with VLOOKUP, the formula is
like =ROUND(VLOOKUP($V2,$B$1:$C$10,2,0),0) as shown in the below picture.
 |
| ROUND and VLOOKUP Function |
The use of ROUND function is very easy and simple,
further you can select how many digits you need after the point or decimal by
specifying num_digits like =ROUND(C2,2). This ROUND function will took the
nearest value after num_digits, for example if we use ROUND function to 7.14885714 number by 2, the result will be
7.15 and if we apply ROUND function to 5.28371428, num_digits by , it will be
5.28.
How to use the ROUNDUP Function
Description
The
Microsoft Excel ROUNDUP function returns a number rounded up to a specified
number of digits. (Rounds away from 0.)
The
ROUNDUP function is a built-in function in Excel that is categorized as a Math/Trig Function. As
a worksheet function, the ROUNDUP function can be entered as part of a formula in
a cell of a worksheet.
Syntax
The
syntax for the ROUNDUP function in Microsoft Excel is:
=ROUNDUP(number, num_digits)
Parameters or Arguments
number
The number
to round up.
num_digits
The number
of digits to round the number up to.
Example
 |
| ROUNDUP function in Excel |
How to use the ROUNDDOWN Function
Description
The
Microsoft Excel ROUNDDOWN function returns a number rounded down to a specified
number of digits. (Always rounds towards 0, just the reverse of ROUNDUP
function).
The
ROUNDDOWN function is a built-in function in Excel that is categorized as
a Math/Trig
Function. As a worksheet function, the ROUNDDOWN function can be
entered as part of a formula in a cell of a worksheet.
Syntax
The
syntax for the ROUNDDOWN function in Microsoft Excel is:
=ROUNDDOWN(number, num_digits)
Parameters or Arguments
number
The number
to round down.
num_digits
The number
of digits to round the number down to.
Example
Please
follow the below picture, this function's working will be clear if you practice
it.
 |
| ROUNDDOWN function in Excel |
As I've shown one example above, you can always use these functions within or with another function to make compound formula.
Thank you for reading this article...
No comments:
Post a Comment