View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonathan Rigley Jonathan Rigley is offline
external usenet poster
 
Posts: 2
Default APR - RATE Function

Hi,

I am trying to use the RATE Function to calculate the Annual Percentage Rate
for the following Loan:

Loan Amount £300
Payments £15 a week
Duration 30 Weeks
Charges £150
Total Amount Payable £450

The Formula I am using is not giving me the correct result which should be
330%, can any one see where I am going wrong ?

=(RATE(30,-15,300*(50%),0,0))

TIA
Jonathan