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.
How to round numbers in Excel?

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.

How to round numbers in Excel?

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.

How to round numbers in Excel?

These are few ways to round off numbers in Excel.

Copy link
Powered by Social Snap