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