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