Microsoft Office Tutorials and References

In Depth Information

Rounding Numbers

Excel provides quite a few functions that round values in various ways. Table 10-2 summarizes these functions.

It's important to understand the difference between rounding a value and formatting a

value. When you format a number to display a specific number of decimal places, for-

mulas that refer to that number use the actual value, which may differ from the dis-

played value. When you round a number, formulas that refer to that value use the roun-

ded number.

Table 10-2: Excel Rounding Functions

Function
Description

CEILING.MATH Rounds a number up 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.MATH

Rounds a number down to the nearest specified multiple

INT

Rounds a number down to make it an integer

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

Chapter 6 contains examples of rounding time values.