Introduction:- ISERROR function in excel is an information function. It is used to find out whether cells contain an error value including the #N/A error. It returns TRUE if cell contains an error value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- … Read more
Introduction:- ISEVEN function in excel is an information function. It is used to find out whether cells contain a numeric value which is even. It returns TRUE if cell contains an even value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISEVEN(VALUE) … Read more
Introduction:- ISFORMULA function in excel is an information function. It is used to find out whether cells contain a formula or not. It returns TRUE if cell contains a formula otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISFORMULA(VALUE) Arguments:- Value: It … Read more
Introduction:- ISLOGICAL function in excel is an information function. It is used to find out whether cells contain a logical value or not. It returns TRUE if cell contains a logical value otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISLOGICAL(VALUE) Arguments:- … Read more
Introduction:- DB function in excel is a financial function. It is used to return the depreciation value of an asset during a mentioned period by using fixed declining balance method. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =DB (cost, salvage, life, period, [month]) Arguments:- … Read more
Introduction:- CUMPRINC function in excel is a financial function. It is used to find cumulative principal 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:- =CUMPRINC(rate, nper, pv, start_period, end_period, type) Arguments:- Rate: It is the rate … Read more
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