INTRATE functionseveral viewers

Since there were several viewers and no responses, I am posting the
answer I found for general interest. The interest rate returned is
simple interest per year with no compounding. The equation is (total
interest earned)/(investment x fractional years invested). Example:
$1000/($10,000 x 1.5yrs) = 6.67% per year.

gfoster07k Wrote:
> Exactly what interest rate does this function return?


--
gfoster07k

What do you mean, no responses?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"gfoster07k" <[email protected]> wrote in message
news:[email protected]...
>
> Since there were several viewers and no responses, I am posting the
> answer I found for general interest. The interest rate returned is
> simple interest per year with no compounding. The equation is (total
> interest earned)/(investment x fractional years invested). Example:
> $1000/($10,000 x 1.5yrs) = 6.67% per year.
>
> gfoster07k Wrote:
>> Exactly what interest rate does this function return?
>
>
> --
> gfoster07k