Formualizer Docs
ReferenceFunctionsFinancial Functions

DOLLARDE

DOLLARDE: Converts fractional-dollar notation into a decimal dollar value.

Summary

This is commonly used for security price formats such as thirty-seconds (fraction = 32).

Remarks

  • fraction is truncated to an integer denominator and must be >= 1.
  • Sign convention: sign is preserved (-x maps to -result).
  • No periodic rate is involved in this conversion.
  • Returns #NUM! when fraction < 1 after truncation.
  • Fractional parsing uses denominator digit width (ceil(log10(fraction))).

Examples

Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null
Example
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
null

FAQ

Why does DOLLARDE truncate fraction?

The denominator is treated as an integer quote base; values below 1 after truncation return #NUM!.

Runtime metadata

Category

Financial

Signature

DOLLARDE(arg1: Number, arg2: Number)

Arity

min 2, max 2

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/financial/tvm.rs

DDB

DDB: Returns declining-balance depreciation for a period using a configurable acceleration factor.

DOLLARFR

DOLLARFR: Converts a decimal dollar value into fractional-dollar notation.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does DOLLARDE truncate fraction?Runtime metadata