How to use DOLLARFR Function in Excel

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:

DOLLARFR Function - How to use DOLLARFR Function in Excel

Syntax:  =DOLLARFR(A2,B2)

Result:

DOLLARFR Function in Excel - How to use DOLLARFR Function in Excel

Based on the Excel spreadsheet above, the following DOLLARFR examples would return:

Syntax: =DOLLARFR(A3,B3)
Result: 2.13

Syntax: =DOLLARFR(A4,B4)
Result: 1.01

Syntax: =DOLLARFR(A5,B5)
Result: 1.03

Syntax: =DOLLARFR(A6,B6)
Result: 1.1

Syntax: =DOLLARFR(A7,B7)
Result: 1.01

Syntax: =DOLLARFR(A8,B8)
Result: 1.03

Syntax: =DOLLARFR(A9,B9)
Result: 1.11

Syntax: =DOLLARFR(A10,B10)
Result: 1.12

Note:

  1. If fraction is not an integer, it is truncated.
  2. If fraction is less than 0, DOLLARFR returns the #NUM! error value.
  3. If fraction is 0, DOLLARFR returns the #DIV/0! error value.

Add a Comment

Your email address will not be published. Required fields are marked *