Excel ROUND, ROUNDUP and ROUNDDOWN Function - Combination of VLOOKUP with ROUND in Microsoft Excel

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