Related Function:

The DOLLARFR function converts a dollar value in decimal notation, into a fractional notation.

### Syntax

=DOLLARFR(decimal_dollar,fraction)

#### Arguments

Argument | Description |
---|---|

decimal_dollar | A decimal number |

fraction | The integer to use in the denominator of a fraction |

#### Examples

A | B | C | D | |
---|---|---|---|---|

1 | Formula | Result | Notes | |

2 | =DOLLARFR(1.0625,16) | 1.01 | Converts to number read as 1 + 1/16 | |

3 | =DOLLARFR(1.625,16) | 1.10 | Converts to a number read as 1 + 10/16 | |

4 | =DOLLARFR(1.09375,32) | 1.03 | Converts to a number read as 1 + 3/32 | |

5 | =DOLLARFR(1.9375,32) | 1.30 | Converts to a number read as 1 + 30/32 | |

6 | =DOLLARFR(1.375,32) | 1.12 | Converts to a number read as 1 + 12/32 |

#### Common Function Error(s)

Problem | What went wrong |
---|---|

#NUM! | Occurs if the supplied fraction argument is < 0 |

#DIV/0! | Occurs if the supplied fraction argument = 0 |

#NAME? | Occurs when Analysis ToolPak add-in is not enabled |

The Excel DOLLARFR and DOLLARDE functions are designed for working with security prices, which are often quoted as fractional values. Some examples are given below:

fractional notation | fraction | decimal |
---|---|---|

1.01 (denominator 16) | 1 1/16 | 1.0625 |

1.1 (denominator 16) | 1 10/16 | 1.625 |

1.03 (denominator 32) | 1 3/32 | 1.09375 |

1.3 (denominator 32) | 1 30/32 | 1.9375 |

1.12 (denominator 32) | 1 12/32 | 1.375 |