BET: Microsoft Excel Functions

Returns the accrued interest for a security that pays interest periodically.

	issue	The date the security is issued.
	first_interest	The date when the initial interest is paid.
	settlement	The date you will pay for the security.
	rate	The annual interest rate or coupon when the security was issued.
	par	The par value of the security.
	frequency	The number of coupon payments per year: 1 = annual 2 = semi annual 4 = quarterly
	basis	The type of day counting to use: 0 = US 30/360 1 = Actual/Actual 2 = Actual/360 3 = Actual/365 4 = European 30/360

REMARKS

		This function is only available if you have the Analysis ToolPak add-in installed.
		Dates must be entered as text strings within quotation marks or as serial numbers.
		The "settlement" date is the date after the "issue" date when the security is traded to the buyer.
		If "issue" is not an integer, it is truncated.
		If "issue" is not a valid date, then #VALUE! is returned.
		If "issue" >= "settlement", then #NUM! is returned.
		If "first_interest" is not an integer, it is truncated.
		If "first_interest" is not a valid date, then #VALUE! is returned.
		If "settlement" is not an integer, it is truncated.
		If "settlement" is not a valid date, then #VALUE! is returned.
		If "rate" <= 0, then #NUM! is returned.
		If "par" <= 0, then #NUM! is returned.
		If "par" is left blank, then 1000 is used.
		If "frequency" is not an integer, it is truncated.
		If "frequency" is any number other than 1, 2 or 4, then #NUM! is returned.
		If "basis" is not an integer, it is truncated.
		If "basis" < 0, then #NUM! is returned.
		If "basis" > 4, then #NUM! is returned.
		If "basis" is left blank, then 0 is used.
		You can use the DATE() function to enter your dates.

EXAMPLES