monthly compound of yield
 

I currently use the 'evaluate' method for figuring 'yield' function. For
'frequency', I would like to use 12 (monthly), but it doesn't work. Only 1
(annually), 2 (semi-annually), and 4 (quarterly) seem to work. Is there any
way to figure yield on a monthly compounding basis? Thanks, Mike Allen