A Brief Discussion of 8 Rounding Functions in Excel

One of the most easiest ways to round off the decimal fraction numbers is to use the rounding functions in Excel. The rounding functions fall in the math and trigonometry functions category in Excel. Microsoft Excel has a total of 8 rounding functions under the math and trigonometry functions category. You can use these functions to round off decimal numbers. In this article, I will discuss those rounding functions in Excel.

A List of 8 Rounding Functions in Excel

1. ROUND Function

Objectives

The ROUND function in Excel is used to round off the numerical values. It can round off numbers to specific values. It can also round off the decimal fraction numbers to a particular number of places after the decimal point.

Syntax

=ROUND(number, num_digits)

Arguments

  • number: It refers to the number to round off.
  • num_digits: The total number of digits you want after the decimal point.

Output

A rounded-off version of the input number.

Example

Round Function in Excel

2. ROUNDUP Function

Objectives

The ROUNDUP function in Excel is used to round up a numerical value to a specific decimal place.

Syntax

=ROUNDUP(number, num_digits)

Arguments

  • number: It refers to the number to round up.
  • num_digits: The total number of digits you want after the decimal point.

Output

A rounded-up version of the input number.

Example

An Overview of ROUNDUP Function in Microsoft Excel

3. ROUNDDOWN Function

Objectives

The ROUNDDOWN function in Excel is used to round down a numerical value to a specific decimal place.

Syntax

=ROUNDDOWN(number, num_digits)

Arguments

  • number: It refers to the number to round off.
  • num_digits: The total number of digits you want after the decimal point.

Output

A rounded-down version of the input number.

Example

An Overview of ROUNDDOWN Function in Excel

4. MROUND Function

Objectives

The MROUND function in Excel rounds off a numerical value to the nearest multiple of a given number. It rounds up or down depending on the distance of the nearest multiple.

Syntax

=MROUND(number, multiple)

Arguments

  • number: It refers to the number to round off.
  • multiple: The number to whose multiple you want to round off your number.

Output

A rounded-off version of the input number.

Example

An Overview of MROUND Function in Microsoft Excel

5. CEILING Function

Objectives

The CEILING function in Excel is used to round up a numerical value to the nearest integer or the nearest multiple of significance.

Syntax

=CEILING(number, significance)

Arguments

  • number: It refers to the number to round up.
  • significance: The number to whose multiple you want to round up your number.

Output

A rounded-up version of the input number.

Example

Examples of CEILING Function in Excel

6. FLOOR Function

Objectives

The FLOOR function in Excel is used to round down a numerical value to the nearest multiple of significance.

Syntax

=FLOOR(number, significance)

Arguments

  • number: It refers to the number to round down.
  • significance: The number to whose multiple you want to round down your number.

Output

A rounded-down version of the input number.

Example

FLOOR Function in Microsoft Excel

7. TRUNC Function

Objectives

The TRUNC function in Excel is used to remove specific digits from the fraction part of a number.

Syntax

=TRUNC(number, [num_digits])

Arguments

  • number: Compulsory. It refers to the number to truncate.
  • num_digits: Non-compulsory. The total number of digits that you want to keep after the decimal point.

Output

A truncated version of the input number.

Example

Examples of TRUNC Function in Excel

8. INT Function

Objectives

The INT function in Excel rounds down a numerical value to the nearest integer number. It removes the fraction part of a decimal fraction number. Thus, the output becomes a rounded-down version of the input number.

Syntax

=INT(number)

Arguments

  • number: It refers to the number to round down.

Output

A rounded-down version of the input number.

Example

An Overview of INT Function in Microsoft Excel

Conclusion

I have discussed a total of 8 rounding functions in Microsoft Excel. You can use those functions to easily round off the decimal fraction numbers in Excel. I hope, this article will help you learn the rounding functions. If you have any queries regarding rounding options in Excel, feel free to share them with me in the comment section. Thanks.

(Visited 38 times, 1 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *