[]

Document Solutions for Excel, Java Edition Overview
Key Features
Getting Started
Features
Templates
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
  - ACCRINT
  - ACCRINTM
  - AMORDEGRC
  - AMORLINC
  - COUPDAYBS
  - COUPDAYS
  - COUPDAYSNC
  - COUPNCD
  - COUPNUM
  - COUPPCD
  - CUMIPMT
  - CUMPRINC
  - DB
  - DDB
  - DISC
  - DOLLARDE
  - DOLLARFR
  - DURATION
  - EFFECT
  - FV
  - FVSCHEDULE
  - INTRATE
  - IPMT
  - IRR
  - ISPMT
  - MDURATION
  - MIRR
  - NOMINAL
  - NPER
  - NPV
  - ODDFPRICE
  - ODDFYIELD
  - ODDLPRICE
  - ODDLYIELD
  - PDURATION
  - PMT
  - PPMT
  - PRICE
  - PRICEDISC
  - PRICEMAT
  - PV
  - RATE
  - RECEIVED
  - RRI
  - SLN
  - SYD
  - TBILLEQ
  - TBILLPRICE
  - TBILLYIELD
  - VDB
  - XIRR
  - XNPV
  - YIELD
  - YIELDDISC
  - YIELDMAT
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
File Operations
Use JDK 8 Date Time API
Document Solutions Data Viewer
API Reference
Release Notes

INTRATE

This function calculates the interest rate for a fully invested security.

Syntax

INTRATE(settle, mature, invest, redeem, [basis])

Arguments

This function has these arguments:

Argument	Description
settle	[Required] Settlement date for the security
mature	[Required] Maturity date for the security
invest	[Required] Amount invested in the security
redeem	[Required] Amount to be received at maturity
basis	[Optional] Integer representing the basis for day count

Remarks

This function returns a #VALUE! error when settle or mature is invalid. Settle, mature, and basis are truncated to integers.

If invest or redeem is less than or equal to 0, a #NUM! error is returned.
If basis is less than 0 or greater than 4, a #NUM! error is returned.
If settle is greater than or equal to mature, a #NUM! error is returned.

Examples

INTRATE(A1,B3,70000,72000,3)

INTRATE(R1C1,R4C4,82000,86500,2)

INTRATE("3/1/2003","5/31/2003",65000,70000,2) gives the result 0.304311074