The Excel DOLLARFR function converts a dollar price in a regular decimal number format to a dollar price in a particular fractional notation used for securities where pricing is given to the nearest 1/8, 1/16, 1/32, etc. The DOLLARDE function does the opposite conversion.
Syntax:= DOLLARFR(decimal_dollar, fraction)
The DOLLARFR function syntax has the following arguments:
- Decimal_dollar Required. A decimal number.
Fraction Required. The integer to use in the denominator of a fraction.
Example: Let’s look at some Excel DOLLARFR function examples and explore how to use the DOLLARFR function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following DOLLARFR examples would return:
- If fraction is not an integer, it is truncated.
- If fraction is less than 0, DOLLARFR returns the #NUM! error value.
If fraction is 0, DOLLARFR returns the #DIV/0! error value.