ACCRINTM() function

[Zumble]

Hi,

I know about the ACCRINTM() function in Excel which returns the
Interest-Accrued
between the Issue date and the Settlement date
at a given Rate
for a given "Par" (= "amount").

What I need is *** a function *** that will return me the Rate
when I have the Issue date and the Settlement date
and the Interest-Accrued
and the Amount.

Any help appreciated.

TIA
Zumble

 

[Niek Otten]

Please don't multi-post. Your question has been answered more than an hour ago in another newsgroup.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I know about the ACCRINTM() function in Excel which returns the
| Interest-Accrued
| between the Issue date and the Settlement date
| at a given Rate
| for a given "Par" (= "amount").
|
| What I need is *** a function *** that will return me the Rate
| when I have the Issue date and the Settlement date
| and the Interest-Accrued
| and the Amount.
|
| Any help appreciated.
|
| TIA
| Zumble
|
|