Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelHow to Round Numbers in Microsoft Excel?

How to Round Numbers in Microsoft Excel?

In this post, youâ€™ll learn about various rounding functions which lets you to round numbers in Microsoft Excel.

Rounding numbers in Excel

There are so many in which a number can be rounded off in Microsoft Excel. Letâ€™s take a look at few of those ways.

ROUND function

This function rounds of the given number into to the number of digits specified in the function parameter.

=ROUND(number,digits)

Conditions:

• The value of the digits can be greater than zero, equal to zero or less than zero.
• If the digit is greater than zero then it gets rounded off to the specified number of decimals.
• If the digit is equal to zero then it gets rounded to the nearest integer.
• If the digit is less than zero then the integer part of the number gets rounded off while the decimals remain unchanged.

ROUNDDOWN function

This function rounds the given number to the given number of digits no matter the digit count.

=ROUNDDOWN(number,digits)

This function rounds off the number towards zero i.e, smallest value.

ROUNDUP function

This function rounds the given number to the given number of decimal places.

=ROUNDUP(number,decimal_places)

This function rounds off the number away from zero i.e, largest value.

These are few ways to round off numbers in Excel.

Share:

You May Also Like

SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021