View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Please check my use of the ACCRINTM function.

That's because you're using intervals that are exactly 6 months apart, which
happens to match the bond payment period.

Try them with any other period, like 15 days which you used in your initial
example.

Regards,
Fred.

"Nth" wrote in message
...
Pls check this out
http://www.fransysco.net/interest/interests.gif

Looks like your suggestion and the ACCRINTM function do the same thing.
They come up with the same results.

Nth