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.
 
Search JabSto ::




Custom Search