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