How to use Excel DDB Function

Introduction:- DDB function in excel is a financial function. It is used to return the depreciation value of an asset during a mentioned period by using double declining balance method or other methods mentioned in Factor argument. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- … Read more

How to use Excel INTRATE Function

Introduction:- INTRATE function in excel is a financial function. It is used to find interest rate of a fully invested security. It is a worksheet function and can be entered in the cell in which value is required. .                           Syntax:- =INTRATE(settlement, maturity, investment, redemption, basis) Arguments:- Settlement: It is the date on which security is … Read more

How to use Excel ISBLANK Function

Introduction:-                 ISBLANK function in excel is an information function. It is used to find out whether cells are empty. It returns TRUE if cell is empty otherwise returns FALSE. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ISBLANK(VALUE) Arguments:- Value:  It is the value which … Read more

How to use Excel ISERR Function

Introduction:- ISERR function in excel is an information function. It is used to find out whether cells contain an error value except for #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

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