deepcalc
DocsDOLLARDE

DOLLARDE

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

Converts fractional dollar to decimal.

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

Examples

=DOLLARDE(1.02, 16)
Result 1.125

Syntax

DOLLARDE(fractional_dollar, fraction)
fractional_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.