Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can some one please explain the actual function of the rate syntax
=RATE(nper,pmt,pv,fv,type,guess) From what i understand this tells me that over a certain amout of years of paying off the loan amount it gives me a interest rate monthly and yearly. but it is not to clear, How come the interest rate changes and if i dont put the minus symbol in the monthly payment cell the outcome is NUM#. This is really confusing and the help menu doesnt explain this syntax very well PLEASE HELP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compound Rate Function | Excel Worksheet Functions | |||
subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
Possible Variable in Rate Function | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Using MIRR, if cash flows are monthly, should rate be / 12? | Excel Worksheet Functions |