Microsoft Office Tutorials and References

In Depth Information

**Rounding Numbers**

Table 10-1:
Excel Rounding Functions

Function Description

CEILING Rounds a number up (away from zero) to the nearest specified multiple

DOLLARDE Converts a dollar price expressed as a fraction into a decimal number

DOLLARFR Converts a dollar price expressed as a decimal into a fractional number

EVEN Rounds a number up (away from zero) to the nearest even integer

FLOOR Rounds a number down (toward zero) to the nearest specified multiple

INT Rounds a number down (towards zero) to make it an integer

ISO.CEILING* Rounds a number up (away from zero) to the nearest integer or to the nearest multiple

of significance; similar to CEILING, but works correctly with negative arguments

MROUND Rounds a number to a specified multiple

ODD Rounds a number up (away from zero) to the nearest odd integer

ROUND Rounds a number to a specified number of digits

ROUNDDOWN Rounds a number down (toward zero) to a specified number of digits

ROUNDUP Rounds a number up (away from zero) to a specified number of digits

TRUNC Truncates a number to a specified number of significant digits

*Indicates a function introduced in Excel 2010

Chapter 6 contains examples of rounding time values.

The following sections provide examples of formulas that use various types of rounding.

Basic rounding formulas

The ROUND function is useful for basic rounding to a specified number of digits. You specify the

number of digits in the second argument for the ROUND function. For example, the formula that

follows returns 123.40 (the value is rounded to one decimal place):

=ROUND(123.37,1)

If the second argument for the ROUND function is zero, the value is rounded to the nearest

integer. The formula that follows, for example, returns 123.00:

=ROUND(123.37,0)