deepcalc
DocsDOLLARFR

DOLLARFR

View as markdown/docs/functions/dollarfr.md Ask Claude about this pageOpens Claude with this page's address

Converts decimal dollar to fractional.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=DOLLARFR(1.125, 16)
Result 1.02

Syntax

DOLLARFR(decimal_dollar, fraction)
decimal_dollar
number required
fraction
number required
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.