As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Round Numbers in Excel: Step-by-Step Guide

Rounding numbers in Excel is a common task that can be accomplished using various functions. In this guide, we'll explore how to round numbers in Excel using the ROUND function, ROUNDUP function, ROUNDDOWN function, MROUND function, FLOOR function, and CEILING function.

The ROUND Function

The ROUND function rounds a number to a specified number of digits. The syntax is:

=ROUND(number, num_digits)

  • number: The number you want to round.
  • num_digits: The number of digits to which you want to round the number.

For example:

  • =ROUND(A2, 1): Rounds the value in cell A2 to one decimal place.
  • =ROUND(A2, -1): Rounds the value in cell A2 to the nearest ten.

Rounding to the Nearest Integer

To round a number to the nearest integer, use the ROUND function with a num_digits argument of 0:

=ROUND(A2, 0)

Rounding to a Specified Number of Decimal Places

To round a number to a specified number of decimal places, use the ROUND function with a num_digits argument greater than 0:

=ROUND(A2, 2)

Rounding Up (ROUNDUP Function)

The ROUNDUP function rounds a number up, away from 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=ROUNDUP(number, num_digits)

  • number: The number you want to round.
  • num_digits: The number of digits to which you want to round the number.

For example:

  • =ROUNDUP(A2, 1): Rounds the value in cell A2 up to one decimal place.
  • =ROUNDUP(A2, -1): Rounds the value in cell A2 up to the nearest ten.

Rounding Down (ROUNDDOWN Function)

The ROUNDDOWN function rounds a number down, toward 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=ROUNDDOWN(number, num_digits)

  • number: The number you want to round.
  • num_digits: The number of digits to which you want to round the number.

For example:

  • =ROUNDDOWN(A2, 1): Rounds the value in cell A2 down to one decimal place.
  • =ROUNDDOWN(A2, -1): Rounds the value in cell A2 down to the nearest ten.

The MROUND Function

The MROUND function rounds a number to the nearest multiple. The syntax is:

excelCopy code

=MROUND(number, multiple)

  • number: The number you want to round.
  • multiple: The multiple to which you want to round the number.

For example:

  • =MROUND(A2, 10): Rounds the value in cell A2 to the nearest ten.

The FLOOR Function

The FLOOR function rounds a number down, toward 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=FLOOR(number, significance)

  • number: The number you want to round.
  • significance: The multiple to which you want to round the number. It can be positive, negative, or 0 (zero). If omitted, it is assumed to be 1.

For example:

  • =FLOOR(A2, -1): Rounds the value in cell A2 down to the next lowest ten.

The CEILING Function

The CEILING function rounds a number up, away from 0 (zero), to the nearest multiple of significance. The syntax is:

excelCopy code

=CEILING(number, significance)

  • number: The number you want to round.
  • significance: The multiple to which you want to round the number. It can be positive, negative, or 0 (zero). If omitted, it is assumed to be 1.

For example:

  • =CEILING(A2, -1): Rounds the value in cell A2 up to the next highest ten.