Learn How to Use Microsoft Excel INTRATE Function

Microsoft Excel INTRATE Function

The main purpose of the Microsoft Excel INTRATE function is to get the interest rate for fully invested security. That implies, with the help of INTRATE function you can able to return the interest rate for a fully invested security. So, with the help of INTRATE function, you can able to get the interest rate for fully invested security.

Return Value of INTRATE Function

The return value will be the interest rate as a percentage. 

Syntax of INTRATE Function

=INTRATE(settlement, maturity, investment, redemption, [basis])

Where the arguments:

• settlement: This is the settlement date of the security.
• maturity: This is the maturity date of the security.
• investment: This is the amount originally invested.
• redemption: This is the amount received at maturity.
• basis: This is the day count basis, defaults to 0 (optional).

How to Use Microsoft Excel INTRATE Function?

So we know that with, Microsoft Excel INTRATE function you can able to get the interest rate for fully invested security. That implies, with the help of INTRATE function you can able to return the interest rate for a fully invested security. So, with the help of INTRATE function, you can able to get the interest rate for fully invested security.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel