View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Davis Davis is offline
external usenet poster
 
Posts: 4
Default 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.