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)

Search JabSto ::

Custom Search