Converts a fractional number (expressed with a decimal numerator) into a decimal value by applying a specified denominator.
Syntax
DOLLARDE(Number; Factor)
Arguments
- Number (required)
The value whose decimal portion is treated as the numerator of a fraction.- Example: 1.1 with Factor = 2 → 1 + 1/2 = 1.5.
- Factor (required)
The denominator of the fraction. Must be a positive integer (decimal places are truncated).- If Factor ≤ 0, returns:
- #NUMBER! (for negative values).
- #DIV/0! (if zero).
- If Factor ≤ 0, returns:
Background
Historically, U.S. stock markets used fractional pricing (e.g., 1¼ dollars). This function standardizes such values into decimals for easier comparison.
- Common denominators: 2 (halves), 4 (quarters), 8 (eighths), 16 (sixteenths).
Example
| Input (Number) | Factor | Interpretation | Result (DOLLARDE) |
| 1.1 | 2 | 1 + 1/2 = 1.5 | 1.5 |
| 1.1 | 4 | 1 + 1/4 = 1.25 | 1.25 |
| 1.1 | 8 | 1 + 1/8 ≈ 1.125 | 1.125 |
| 2.2 | 4 | 2 + 2/4 = 2.5 | 2.5 |
| 2.2 | 8 | 2 + 2/8 = 2.25 | 2.25 |
Notes
- Limitation: Decimals beyond the factor’s precision are ignored.
- Example: 1.12 with Factor = 8 → Only 1.1 is read as 1 + 1/8 (=1.125).
- Inverse Function: Use DOLLARFR() to convert decimals back to fractional notation.