How to use Excel COUPDAYS Function

Introduction:- COUPDAYS function in excel is a financial function. It is used to retrieve number of days in the coupon period including the settlement date. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPDAYS(Settlement, Maturity, Frequency, basis) Arguments:- Settlement:  It is the settlement date of the security. Maturity:  It is the maturity date of the security. Frequency: Number of coupon payments per year. Basis: It is the day count basis…

Continue Reading

How to use Excel COUNTIFS Function

Introduction:- COUNTIFS function in excel is a statistical function. This function is used to count the number of cells that meet a certain one or more criteria. It can be used to count cells containing dates, numbers, text etc. provided they match certain criteria. This function also supports logical operators and wildcards. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNTIFS(Range1, Criteria1, Range2, Criteria2,……) Arguments:- Range1: It is the 1st…

Continue Reading

How to use Excel COUNTIF Function

Introduction:- COUNTIF function in excel is a statistical function. This function is used to count the number of cells that meet a certain single criteria. It can be used to count cells containing dates, numbers, text etc. provided they match certain criteria. This function also supports logical operators and wildcards. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNTIF(Range, Criteria) Arguments:- Range:  It is the range of cells which will…

Continue Reading

How to use Excel COUNTBLANK Function

Introduction:- COUNTBLANK function in excel is a statistical function. This function is used to count empty cells and cells containing text values, numbers, logical values etc. are not used in counting. This is a worksheet function and can be entered into the cell in which COUNTBLANK is required. Syntax:- =COUNTBLANK(Range) Arguments:- Range: It is the range of cells from which blank cells will be counted. Keynotes:- COUNTBLANK function can use up to 255 additional values.Text values, logical values, empty cells…

Continue Reading

How to use Excel COUNTA Function

Introduction:- COUNTA function in excel is a statistical function. This function is used to count the number of values that are numbers, text, error values, logical values, empty text; usually these are the cells that contain numbers, text, error values, logical values, empty text. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNTA(value1, value2, …., …) Arguments:- Value1:   1st range of values or reference to a cell Value2:   2nd range…

Continue Reading

How to use Excel COUNT Function

Introduction:- COUNT function in excel is a statistical function. This function is used to count the number of values that are numbers; usually these are the cells that contain numbers. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COUNT(value1, value2, …., …) Arguments:- Value1:   1st range of values or reference to a cell Value2:   2nd range of values or reference to a cell Keynotes:- COUNT function can use up to…

Continue Reading

How to use Excel CORREL Function

Introduction:- CORREL function in excel is a statistical function. It is used to find correlation between two variables and gives correlation coefficient having value between +1 and -1. A value of +1 means a perfect directly proportional relation is present and a value of -1 means a perfect inversely proportional relation is present.  It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =CORREL(array1, array2) Arguments:- Array1:   1st range of values Array2:  …

Continue Reading

How to use Excel AMORLINC Function

Introduction:- AMORLINC function in excel is a financial function. It is used to retrieve the depreciation value for every accounting period. It is mainly useful in prorated depreciation calculation. It is different from AMORDEGRC function in a way that in AMORDGERC function, depreciation coefficient is used depending on life of assets. Syntax:- =AMORLINC(cost, date_purchased, first_period, salvage period, rate, basis) Arguments:- Cost: It is cost of the assets. Date_Purchased: It is the date on which assets is purchased. First_Period:  It is…

Continue Reading

How to use Excel ACCRINTM Function

Introduction:- ACCRINTM function in excel is a financial function. It is used to find accrued interest for a security that pays interest at maturity. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ACCRINTM(issue_date, maturity_date, rate, par, basis) Arguments:- Issue_Date: It is the date on which security is used. Maturity_Date: It is the date on which security will be matured. Rate: Annual coupon rate of the security. Par: It is the…

Continue Reading

How to use Excel AMORDEGRC Function

Introduction:- AMORDEGRC function in excel is a financial function. It is used to retrieve the depreciation value for every accounting period. It is mainly useful in prorated depreciation calculation. It is different from AMORLINC in a way that here depreciation coefficient is used depending on life of assets. Syntax:- =AMORDEGRC(cost, date_purchased, first_period, salvage period, rate, basis) Arguments:- Cost: It is cost of the assets. Date_Purchased: It is the date on which assets is purchased. First_Period:  It is the date on…

Continue Reading
Close Menu
×

Cart