Microsoft Office Tutorials and References

In Depth Information

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

market quotes.

Working with feet and inches

A problem that has always plagued Excel users is how to work with measurements that are in feet and inches.

Excel doesn't have any special features to make it easy to work with this type of measurement units, but in some

cases, you can use the DOLLARDE and DOLLARFR functions.

If you enter
5'9"
into a cell, Excel interprets as a text string — not five feet, nine inches. But if you enter the value

as 5.09, you can work with it as a value by using the DOLLARDE function. The following formula returns
5.75,

which is the decimal representation of five feet nine inches expressed as fractional feet.

=DOLLARDE(5.09,12)

If you don't work with fractional inches, you can even create a custom number format, as shown in column G of

Figure10-3:

#” ft”. 00” in.”

The worksheet shown here uses a custom number format to display a value that represents feet and inches.

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
(and is interpreted as “nine and one-quarter”):

=DOLLARFR(9.25,4)