Yield function in Access

[Guest]

Hi,

I'm converting an excel-based database into MS Access. As part of this, I need to compute the yield to maturity (or internal rate of return) for each bond in a bonds table. Is there any way I can use Excel's "yield" function for this or is there an add-in available for this?

Thanks!

Tony W.

 

[Douglas J. Steele]

It's a little tricky, but it can be done. Yield isn't an native Excel
function: it's from one of the add-ins. Check
http://support.microsoft.com/?id=198571 for instructions of how to do it.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Hi,

I'm converting an excel-based database into MS Access. As part of this, I

need to compute the yield to maturity (or internal rate of return) for each
bond in a bonds table. Is there any way I can use Excel's "yield" function
for this or is there an add-in available for this?