How to use Excel ISERROR Function

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

How to use Excel ISERROR Function Read More »

How to use Excel ISEVEN Function

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

How to use Excel ISEVEN Function Read More »

How to use Excel ISFORMULA Function

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 …

How to use Excel ISFORMULA Function Read More »

How to use Excel ISLOGICAL Function

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

How to use Excel ISLOGICAL Function Read More »

How to use Excel DB Function

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

How to use Excel DB Function Read More »

How to use Excel CUMPRINC Function

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 …

How to use Excel CUMPRINC Function Read More »

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 …

How to use Excel CUMIPMT Function 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 …

How to use Excel T Function 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) …

How to use Excel EXPON.DIST Function 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 …

How to use Excel DEVSQ Function Read More »