Formualizer Docs
ReferenceFunctionsFinancial Functions

DOLLARFR

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

Summary

This is the inverse-style formatting helper used for quoted fractional price conventions.

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.
  • Fraction output is encoded by 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

How does DOLLARFR encode the fractional part?

It scales the numerator into decimal digits based on ceil(log10(fraction)), preserving the input sign.

Runtime metadata

Category

Financial

Signature

DOLLARFR(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

DOLLARDE

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

EFFECT

Converts a nominal annual rate into an effective annual rate.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does DOLLARFR encode the fractional part?Runtime metadata