Formula Archives - Excelhub

How to use Excel DEVSQ Function

Introduction:- DEVSQ function in excel is a statistical function. This function is used to find the sum of the squared deviations from the mean from a sample. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =DEVSQ(Number1,Number2, ……) Arguments:- Number1: First value or reference to the cell containing first value. Number2: Second value or reference to a cell containing second value. Keynotes:- Arguments may be in form of numbers, names, arrays,…

How to use Excel COVARIANCE.S Function

Introduction:- COVARIANCE.S function in excel is a statistical function. This function is used to find the sample co-variance of two data sets. For example it can be used to keep check on how to assets are moving together. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COVARIANCE.S(Array1, Array2) Arguments:- Array1: 1st range of cells. Array2: 2nd range of cells. Keynotes:- The arguments used should be numbers or range of cells…

How to use Excel COVARIANCE.P Function

Introduction:- COVARIANCE.P function in excel is a statistical function. This function is used to find the variability of two data sets which are co-variant to each other. For example if we needs to find whether greater levels of inflation leads to greater levels of inflation, than we can use excel function. This is a worksheet function and can be entered into the cell in which count is required. Syntax:- =COVARIANCE.P(Array1, Array2) Arguments:- Array1: 1st range of cells. Array2: 2nd range…

How to use Excel COUPPCD Function

Introduction:- COUPPCD function in excel is a financial function. It is used to retrieve the previous coupon date before the settlement date of a security. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPPCD(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 COUPNUM Function

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

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

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…