Changes

==Description==

==Description==

This function returns the accumulated interest for a security that pays interest at maturity.

*This function returns the accumulated interest for a security that pays interest at maturity.

Issue, Basis, Settlement be integers.

*Issue, Basis, Settlement be integers.

ACCRINTM shows the error value when  R less-than or equal to 0 or if Par less-than or equal to 0, basis<0 or basis>4 and I date greathearted or equal to settle date,

*ACCRINTM shows the error value when:

R less-than or equal to 0

if Par less-than or equal to 0

basis<0 or basis>4

I date greathearted or equal to settle date,

<math>ACCRINTM = Par * Rate * (M /D)</math>

 

<math>M</math> number of days counted from issue date to maturity date.

ACCRINTM=Par χ Rate χ(M /D)

<math>D</math> Annual Year Basis.

 

 

'''M''' - number of days counted from issue date to maturity date.

 

'''D''' - Annual Year Basis.

 

Lets see an example in (Column2,Row2)

Lets see an example in (Column2,Row2)