Home > How To > Rate Formula Excel Error

# Rate Formula Excel Error

## Contents

Pmt is the payment made each period and cannot change over the life of the annuity. Look up Excel's help on the topic. Skip to main content Login Cart Exceljet Quick, clean, and to the point Training Videos Functions Formulas Shortcuts Blog Search form Search Excel RATE Function Purpose Get the interest rate per Yes No Great!

Note that the solution value is very unusual, in problems with values closer to more common numbers of the real life the guess value can be ommited. error, enter values as unformatted numbers, like 1000, instead. I always get the error "NUM". Excel might also show the #NUM!

## How To Find Interest Rate In Excel

Syntax RATE(nper, pmt, pv, fv, type, guess) See PV for a complete description of the arguments nper, pmt, pv, fv, and type. I always get the error "NUM". Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? On the Formulas tab, under Calculation options, check the Enable iterative calculation box. error =RATE function I guess value to decimal closer to 0, but still did not resolve the #num! Excel Rate Function Mathematical Formula Click Show Calculation Steps if it’s available, and pick the resolution that works for your data.

Fv is the future value, or a cash balance you want to attain after the last payment is made. Which version do I have? Thanks in advance! RATE is calculated by iteration and can have zero or more solutions.

Please try the request again. How To Calculate Compound Interest Rate In Excel Search strategy: My own knowledge and the Excel help. Nper is the total number of payment periods in an annuity. Post a question in the Excel community forum Help us improve Excel Do you have suggestions about how we can improve the next version of Excel?

## Rate Function

Popular Topics Functions | Formulas Pivot Tables Conditional formatting VLOOKUP | IF function Keyboard shortcuts Excel pros | Books I find your email tips extremely helpful for excel! - Jill Excel Thank you. How To Find Interest Rate In Excel If you omit guess, it is assumed to be 10 percent. How To Calculate Interest Rate In Excel 2013 To fix this, change the number of times Excel iterates formulas: Click File > Options.

The payments are to be made at the start of each month.Formula:A1Monthly interest rate required to save\$20,000 over 2 yrs, with an investmentof \$800 per mth (payments made atstart of each Note I: my Excel version uses ";" as arguments separator, I realize that yours use ","; please use the apropiate separator for your version. How can we improve it? Master absolute and relative addresses, named ranges, errors, and troubleshooting. Nper Function Excel