• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

RATE in Excel

September 5, 2021 by Andrew Childress
Rate function in Excel

It’s often useful to calculate the interest rate of a loan, for example. Fortunately, Excel can perform this math for you. Here's how to use RATE in Excel.

Excel works with a variety of data, including financial information. It’s often useful to calculate the interest rate of a loan, for example. Fortunately, Excel can perform this math for you. Let’s learn how to use RATE in Microsoft Excel.

How to Use RATE in Excel

Imagine that you have a loan, and you need to know the annual interest rate for it. These calculations can be done manually, but with Excel’s RATE function, you don’t have to do so.

To use RATE, you’ll need three inputs: the amount of your loan, the monthly payment, and the number of periods in the loan.

For example, here, we’ll use $10,000 as the loan amount, $185 as the monthly payment, and 72 as the number of periods. Place these numbers in cells A1, A2, and A3, respectively.

Then, click into any empty cell in your workbook. Begin by typing an = sign. This tells Excel that you’re inputting a formula into the cell. Then, insert your RATE function. Your formula so far reads:

=RATE(

Rate in Excel

Excel will first need the number of periods. Click into cell A3, then type a comma. Next, click into cell A2 to add the monthly payment amount. Add a final comma, then type a – sign. To find the rate, you’re subtracting the loan amount inside the function.

Click into cell A1, then type ). Now, your formula is:

=RATE(A3,A2,-A1)

Interest rate in Excel

Finally, to find the annual rate, multiply the function by 12:

=RATE(A3,A2,-A1)*12

Hit Enter on your keyboard, and Excel will return the annual interest rate: 9.95%.

Rate function in Excel

As you can see, Excel’s RATE function makes it quick and easy to calculate interest rates. You need only three simple inputs, and your spreadsheets with this function inside will quickly do the calculations for you. It’s the perfect way to save time and maintain perfect accuracy.

Category: Excel Functions

About Andrew Childress

Previous Post:Iferror ExcelIFERROR in Excel
Next Post:Consolidate in ExcelConsolidate in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top