## How to use Excel COUPDAYBS Function

Introduction:- COUPDAYBS function in excel is a financial function. It is used to retrieve number of days from the start of coupon period to the settlement date. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPDAYBS(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…

## How to use Excel COUPDAYSNC Function

Introduction:- COUPDAYSNC function in excel is a financial function. It is used to retrieve number of days from the settlement date to the next coupon period. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPDAYSNC(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…

## 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…

## 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…

## 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…

## 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…

## 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…

## 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…

## 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:  …

## 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…

×