Computing simple interest
What's the easiest way to compute the annual percentage rate on a given cell.
I typically multiply the principal amount by the interest rate/divide by
365/and then multiply by the number of days since the loan was made. Is
there an easier way to do this by use of one of the date/time functions in
Excel?
Thanks.
|