Microsoft Office Tutorials and References

In Depth Information

**Rounding Numbers**

Working with fractional dollars

The DOLLARFR and DOLLARDE functions are useful when working with fractional dollar values,

as in stock market quotes.

Consider the value $9.25. You can express the decimal part as a fractional value ($9 1/4, $9 2/8,

$9 4/16, and so on). The DOLLARFR function takes two arguments: the dollar amount and the

denominator for the fractional part. The following formula, for example, returns 9.1 (the .1 decimal

represents 1/4):

=DOLLARFR(9.25,4)

In most situations, you won’t use the value returned by the DOLLARFR function in other

calculations. In the preceding example, the result of the function will be interpreted as

9.1, not 9.25. To perform calculations on such a value, you need to convert it back to a

decimal value by using the DOLLARDE function.

The DOLLARDE function converts a dollar value expressed as a fraction to a decimal amount. It

also uses a second argument to specify the denominator of the fractional part. The following

formula, for example, returns 9.25:

=DOLLARDE(9.1,4)

The DOLLARDE and DOLLARFR functions aren’t limited to dollar values. For example,

you can use these functions to work with feet and inches. You might have a value that

represents 8.5 feet. Use the following formula to express this value in terms of feet and

inches. The formula returns 8.06 (which represents 8 feet, 6 inches).

=DOLLARFR(8.5,12)

Another example is baseball statistics. A pitcher may work 6
2
⁄
3
innings, and this is

usually represented as 6.2. The following formula displays 6.2:

=DOLLARFR(6+2/3,3)

Using the INT and TRUNC functions

On the surface, the INT and TRUNC functions seem similar. Both convert a value to an integer.

The TRUNC function simply removes the fractional part of a number. The INT function rounds a

number down to the nearest integer, based on the value of the fractional part of the number.