YIELD(settlement,maturity,rate,pr,redemption,frequ ency,basis)

Frequency is the number of coupon payments per year. For annual payments,
frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4;
for monthly, frequency = 12 .


HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"DDR" wrote:

I want to use the YIELD function for payments received monthly. Is there a
way to include 12 in the frequency?