Financial
All versions
◉ 16 views
=DOLLARFR()
Use DOLLARFR to convert decimal numbers to fractional dollar numbers, such as securities prices.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=DOLLARFR(decimal_dollar, fraction)
Hover argument names in the table for details.
Output typeNumber
Popularity4 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =DOLLARFR() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
decimal_dollar |
Number | Required | A decimal number. |
fraction |
Number | Required | The integer to use in the denominator of a fraction. |
▣ Examples
Converts the decimal number 1.125 to a number read as 1 and 2/16.
=DOLLARFR(1.125,16)
Result:
1.02
Converts the decimal number 1.125 to a number read as 1 and 4/32.
=DOLLARFR(1.125,32)
Result:
1.04
§ Remarks
- 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.
✦ Tips
- If fraction is not an integer, it is truncated.
⚠ Common Errors
#NUM!
If fraction is less than 0, DOLLARFR returns the #NUM! error value.
Fix: Write a positive number
#DIV/0!
If fraction is 0, DOLLARFR returns the #DIV/0! error value.
Fix: برای fraction مقدار صفر وارد نکنید؛ عددی بزرگتر از صفر انتخاب کنید.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!