How to use Excel CUMIPMT Function

Introduction:- CUMIPMT function in excel is a financial function. It is used to find cumulative interest of a loan between the start and end period. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =CUMIPMT(rate, nper, pv, start_period, end_period, type) Arguments:- Rate: It is the rate … Read more

How to use Excel T Function

Introduction:- T function are text/string function in excel. It is used to retrieve text from a given text value and also retrieves blank strings for numbers, logical values, dates etc. It is a worksheet function and can be entered in the cell in which value is required. .                                                                 Syntax:- =T(Value) Arguments:- Value: Value or reference … Read more

How to use Excel EXPON.DIST Function

Introduction:-     EXPON.DIST function in excel is a statistical function. This function is used to find the exponential distribution. It is an update over EXONDIST function and is available in Excel 2010 and newer versions. It is a worksheet function and can be entered into the cell in which value is required. Syntax:-                                     =EXPON.DIST(X, Lambda, Cumulative) … Read more

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 … Read more

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 … Read more

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 … Read more

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 … Read more

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:  … Read more

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 … Read more