Related Function:

The DOLLARDE function converts a dollar value, expressed as a fraction, as a dollar value, expressed as a decimal.

### Syntax

=DOLLARDE(fractional_dollar,fraction)

Note: The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the fraction part by 16, e.g. 1.02 represents $1.125 ($1 + 2/16 = $1.125).

#### Arguments

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

fractional_dollar | A number expressed as an integer part and a fraction part, separated by a decimal symbol |

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

#### Examples

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

1 | Formula | Result | Notes | |

2 | =DOLLARDE(1.01,16) | 1.0625 | Read as 1 + 1/16 because the fraction value is 16 | |

3 | =DOLLARDE(1.1,16) | 1.625 | Read as 1 + 10/16 because the fraction value is 16 | |

4 | =DOLLARDE(1.03,32) | 1.09375 | Read as 1 + 3/32 because the fraction value is 32 | |

5 | =DOLLARDE(1.3,32) | 1.9375 | Read as 1 + 30/32 because the fraction value is 32 | |

6 | =DOLLARDE(1.12,32) | 1.375 | Read as 1 + 12/32 because the fraction value is 32 |

#### Common Function Error(s)

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

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

#DIV/0! | Occurs if the supplied value of fraction is equal to 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 |