Financial All versions ◉ 42 views

=DOLLARDE()

Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices. 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. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016

=DOLLARDE(fractional_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 =DOLLARDE() 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)

Download DOLLARDE.xlsx ~ 8–12 KB · No macros

Quiz this function

%d questions — syntax, example & errors — test yourself!

Start quiz →

◧ Arguments

Argument	Type	Required	Description
`fractional_dollar`	Number	Required	A number expressed as an integer part and a fraction part, separated by a decimal symbol.
`fraction`	Number	Required	The integer to use in the denominator of the fraction.

▣ Examples

Converts 1.02, read as 1 and 2/16, to a decimal number (1.125). Because the fraction value is 16, the price has a precision of 1/16 of a dollar. =DOLLARDE(1.02,16)

Result: 1.125

Converts 1.1, read as 1 and 10/32, to a decimal number (1.3125). Because the fraction value is 32, the price has a precision of 1/32 of a dollar. =DOLLARDE(1.1,32)

Result: 1.3125

§ Remarks

If fraction is not an integer, it is truncated.
If fraction is less than 0, DOLLARDE returns the #NUM! error value.
If fraction is greater than or equal to 0 and less than 1, DOLLARDE 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, DOLLARDE returns the #NUM! error value.

Fix: Write a positive number

#DIV/0! If fraction is greater than or equal to 0 and less than 1, DOLLARDE 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!