deepcalc
DocsRATE

RATE

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

Returns interest rate per period.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=RATE(360, -536.82, 100000)
Result 0.00416664453635995

Syntax

RATE(nper, pmt, pv, [fv], [type], [guess])
nper
number required
pmt
number required
pv
number required
fv
number optional
type
number optional
guess
number optional

Errors

#NUM!
=RATE(2, 2, 2)
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.