Excel ACCRINT Function / Accrued interest calculate in Excel

Channel:
United States SL Data Hub
Subscribers:
512
Published on ● Video Link: https://www.youtube.com/watch?v=W6w1FHzSIlw


Duration: 2:55
29 views
1

Description
The Microsoft Excel ACCRINT function returns the accrued interest for a security that pays interest on a periodic basis.

The ACCRINT function is a built-in function in Excel that is categorized as a Financial Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the ACCRINT function can be entered as part of a formula in a cell of a worksheet.

Syntax
The syntax for the ACCRINT function in Microsoft Excel is:

ACCRINT( issue_date, first_interest_date, settlement_date, rate, par, frequency, [basis], [calculation_method] )

Returns
The ACCRINT function returns a numeric value.

Applies To
Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007
Type of Function
Worksheet function (WS)



Other Videos By SL Data Hub


2023-08-10Bubble Rainbow | Gaming Videos | Top Games | Game Strategies | Gaming
2023-08-08Gaming Videos | Top Games | Game Strategies | Gaming Highlights | Candy Crush Saga | Anime Games
2023-03-30ACOS Function | Returns the arccosine of a number
2023-03-30ACCRINTM function | Returns the accrued interest for a security that pays interest at maturity
2021-10-09Excel VLOOKUP Function / how to use VLOOKUP function
2021-09-29Excel SUM Function
2021-09-29Excel Average Function / Average of a group of numbers
2021-09-29Excel MAX function / Maximum value in data set
2021-09-29Excel MIN function / Minimum value
2021-09-28Transform/ Compute Variables using IBM SPSS
2021-09-28Excel ACCRINT Function / Accrued interest calculate in Excel
2021-09-28Excel ABS Function / Absolute value
2021-09-27How to Add / Install the Data Analysis ToolPak in Microsoft Excel 2016
2021-08-03Create a waterfall chart in Excel 2016
2021-08-02Create a Treemap chart in Excel 2016
2021-08-01Create a Sunburst chart in Excel 2016 [ 1 min ]
2021-08-01IBM SPSS Research data Analysis A to Z
2021-07-30Reliability analysis/ Cronbach's Alpha/ pilot test using IBM SPSS
2021-07-30Transform/ Compute Variables using IBM SPSS
2021-07-27How to delete all posts in Facebook page 2023
2021-07-26Progress Circle Chart II using Excel 2016


Tags:
sl
sl data hub
data hub
excel
excel function
excel formula
ACCRINT
accrint function
function
formula
financial function
accrued interest
Accrued interest calculate in Excel