### Excel INTRATE Function

This Excel Tutorial demonstrates how to use the Excel INTRATE Function in Excel to calculate the interest rate of a bond, with formula examples.

## INTRATE Function Description:

The INTRATE Function Calculates the interest rate of a fully invested security.

## Formula Examples: Example Formula Result
1 =INTRATE(C5,D5,E5,F5,G5) 6.66666666666667E-02
2 =INTRATE(C6,D6,E6,F6,G6) 0.066703196347032

## Syntax and Arguments:

The Syntax for the INTRATE Formula is:

### Function Arguments ( Inputs ):

settlement – The settlement date, represented by a date serial number.

maturity – The maturity date, represented by a date serial number.

investment – The amount invested in the security.

redemption – The redemption price per \$100 of face value.

basis – OPTIONAL. The basis for which to calculate the number of days in a year.

Use the INTRATE Function to calculate the interest rate of a bond or similar security.

The result of the INTRATE Function may appear as a decimal. Change the cell Number Formatting to Percentage to display the function result as a percentage: ## INTRATE Examples in VBA You can also use the INTRATE function in VBA. Type:
`Application.Worksheetfunction.Intrate(value,value_if_error)`
For the function arguments (value, etc.), you can either enter them directly into the function, or define variables to use instead.

`=AND(`  