Microsoft Office Tutorials and References
In Depth Information
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
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:
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).
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:
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.