Quick Navigation
DOLLARFR Function
Summary
The DOLLARFR function converts a standard decimal dollar amount into a fractional dollar representation, commonly used for displaying securities prices and financial instruments that trade in fractional increments.
Syntax
DOLLARFR(decimal_dollar, fraction)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| decimal_dollar | Number |
Yes | Decimal number representing the dollar amount to convert into fractional format |
| fraction | Number |
Yes | Integer specifying the denominator for the fractional part (e.g., 16 for 16ths) |
Using the DOLLARFR Function
DOLLARFR is essential for financial professionals working with markets that use fractional pricing. Convert standard decimal prices to traditional fractional formats used in bonds, treasuries, and certain stock exchanges.
Common DOLLARFR Examples
Convert to 16ths (Common for Stocks)
=DOLLARFR(1.125,16)Converts 1.125 to 1 2/16, displayed as 1.02 in Excel.
Convert to 32nds (Common for Bonds)
=DOLLARFR(1.125,32)Converts 1.125 to 1 4/32, displayed as 1.04 in Excel.
Treasury Bill Pricing
=DOLLARFR(A1,64)Converts decimal price in A1 to 64ths format used in T-bill quotes.
Frequently Asked Questions
Common Errors and Solutions
#NUM! error
Cause: Fraction argument is negative
Solution: Use only positive integers for the fraction parameter
#DIV/0! error
Cause: Fraction argument is zero
Solution: Provide a positive integer greater than zero
#VALUE! error
Cause: Non-numeric input for decimal_dollar or fraction
Solution: Ensure both arguments are valid numbers
Notes
- Fraction is truncated if not an integer
- Common denominators: 2, 4, 8, 16, 32, 64, 100
- Result displays as decimal but represents fractional dollars
- Excel stores as decimal value for calculations
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+