DOLLARDE
Convert fractional dollar prices to decimals with DOLLARDE. Essential for bond trading, stock quotes, and financial analysis.
Excel
Google SheetsExcelGoogle Sheets=DOLLARDE(fractional_dollar, fraction)Quick Answer
Function DOLLARDE function converts a dollar price expressed as a fraction into a decimal number. Use =DOLLARDE(fractional_dollar, fraction) where fractional_dollar is the value to convert and fraction is the denominator (commonly 32 for bonds). For example, =DOLLARDE(1.02, 32) converts 1 and 2/32 dollars to 1.0625.
Practical Examples
Basic Bond Price Conversion
Convert a bond price quoted in 32nds to decimal format
Stock Price Conversion from 16ths
Convert stock prices quoted in sixteenths to decimal
Treasury Bill Pricing
Convert T-bill prices from fractional to decimal notation
Batch Conversion with Cell References
Convert multiple fractional prices in a spreadsheet
Error Handling for Invalid Fractions
Protect against calculation errors with IFERROR wrapper
Common Errors and Solutions
DOLLARDE returns #NUM! error
The fraction parameter is less than 1
Ensure the fraction parameter is at least 1. Common values are 16, 32, or 64 for financial applications.
Validate fraction input before calculation or use data validation in Excel
Example:
DOLLARDE returns #VALUE! error
Non-numeric values provided as arguments
Verify both arguments are numbers. Check for text values or empty cells.
Use ISNUMBER() to validate inputs before calling DOLLARDE
Example:
Wrong decimal conversion
Using wrong fraction denominator (e.g., using 32 when price is in 16ths)
Verify the fraction convention used in your pricing source. Bonds typically use 32nds, older stocks used 8ths or 16ths.
Document the fraction convention in your spreadsheet header
Example:
Best Practices and Pro Tips
Validate Fraction Denominator
Always ensure the fraction parameter is a positive integer greater than or equal to 1. Use data validation or conditional logic to prevent invalid inputs that would cause #NUM! errors.
Document Fraction Convention
Clearly label columns or add notes indicating which fraction denominator is being used (32nds, 16ths, etc.). Different securities markets use different conventions, and confusion can lead to significant pricing errors.
Use Error Handling
Wrap DOLLARDE in IFERROR or IFNA functions to gracefully handle invalid inputs and provide user-friendly error messages instead of Excel error codes.
Maintain Precision
When working with financial calculations, format cells to display adequate decimal places (typically 4-6 for bond prices) to maintain calculation accuracy and meet industry standards.
Combine with Financial Functions
Use DOLLARDE as part of larger financial models by combining it with PRICE, YIELD, ACCRINT, and other bond-related functions. This creates comprehensive analysis tools for fixed-income securities.
Need Help with DOLLARDE?
Stop struggling with formula syntax. Use AskFormulas to generate validated formulas instantly with our AI-powered tool.
Example Excel formula:
Related Formulas
The ACCRINT function calculates accrued interest for a security that pays periodic interest, enabling accurate financial reporting and bond valuation.
ExcelSheetsConvert decimal dollar prices to fractional notation with DOLLARFR. Essential for bond pricing, securities trading, and financial reporting systems.
ExcelSheetsThe ACCRINTM function calculates accrued interest for securities that pay interest at maturity, essential for bond valuation and analysis.
ExcelSheetsThe AMORDEGRC function calculates depreciation for French accounting system assets using the declining balance method with specific coefficient rules
Excel