| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter a function that has more than 7 nested functions | Excel Worksheet Functions | |||
| Rate function with #Num! result | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| a function giving the interest rate for inv x for period y & bal z | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
