How to use Excel EFFECT Function

Introduction:- EFFECT function in excel is a financial function. It is used to find effective annual interest rate. It is defined as the actual interest rate earned annually due to compounding. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =EFFECT(nominal_rate, npery) Arguments:- Nominal_Rate: It is … Read more

How to use Excel ERROR.TYPE Function

Introduction:- ERROR.TYPE function in excel is an information function. It is used to retrieve a number corresponding to an error value. If there is no error than #N/A is displayed. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ERROR.TYPE(error_value) Arguments:- Error_Value: The error value whose … Read more

How to use Excel DURATION Function

Introduction:- DURATION function in excel is a financial function. It is used to find duration of a security in Macaulay form using Macaulay duration formula. Duration is expressed as weighted average of cash flows at present. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =DURATION … Read more

How to use Excel FV Function

Introduction:-     FV function in excel is a financial function. It is used to find the future value of an investment. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =FV (rate, nper, pmt, [pv], [type]) Arguments:- rate – It is the interest rate per period. nper – It … Read more

How to use Excel DISC Function

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

How to use Excel FVSHEDULE Function

Introduction:- FVSCHEDULE function in excel is a financial function. It is used to find the future value of an initial principal after a number of compound interest rates. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =FVSCHEDULE (Principal, Schedule) Arguments:- Principal: It is the present … Read more

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