How to Use INTRATE() in Google Sheets

Description

Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.

How To Actually Use INTRATE() in Sheets

INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])

Try INTRATE yourself

Use the INTRATE formula to calculate the effective interest rate for the investment with the buy date in A1, sell date in B1, buy price in C1, and sell price in D1. The formula should return the interest rate as a decimal.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas

Transcript-matched member videos for INTRATE(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Calculate ROAS in Google Sheets

Calculate Return on Ad Spend with a formula combination. Bonus: create a...

Intermediate

CONCATENATE() ROUND()

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Google Sheet Basics - The Absolute Basics

Let's start at the basics of Google Sheets. Where every beginner spreads...

Beginner

Unlock these tutorials

Learn more about the INTRATE() formula:

Generate a INTRATE() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses INTRATE(). 2 free AI generations, no signup. Members get unlimited use.

Generate a INTRATE() formula