by Ilker | Aug 27, 2019 | Excel Formulas
The Excel EFFECT function is a Financial formula that calculates and returns the effective annual interest rate, for a given nominal annual interest rate and number of compounding periods per year. The effective annual interest rate is used to compare financial loans...
by Ilker | Aug 27, 2019 | Excel Formulas
The DURATION Excel function is a Financial formula that calculates and returns the annual duration of a security based on the Macauley duration formula. In this guide, we’re going to show you how to use the DURATION function and also go over some tips and error...
by Ilker | Aug 26, 2019 | Excel Formulas
The Excel YIELD function is a Financial formula that calculates and returns the yield on a security that pays a periodic interest. A common use case for the YIELD function is calculating bond yields. In this guide, we’re going to show you how to use the Excel YIELD...
by Ilker | Aug 22, 2019 | Excel Formulas
The Excel PRICEMAT function is a Financial formula that calculates and returns the price per $100 face value of a security that pays interest at maturity. In this guide, we’re going to show you how to use the PRICEMAT function and also go over some tips and error...
by Ilker | Aug 21, 2019 | Excel Formulas
The PRICEDISC Excel function is a Financial formula that calculates and returns the price per $100 face value of a discounted security. In this guide, we’re going to show you how to use the PRICEDISC function and also go over some tips and error handling methods....
by Ilker | Aug 20, 2019 | Excel Formulas
The Excel PRICE function is a Financial formula that calculates and returns the price per $100 face value of a security that pays periodic interest. In this guide, we’re going to show you how to use the PRICE function and also go over some tips and error handling...
by Ilker | Aug 8, 2019 | Excel Formulas
The Excel FALSE function is a Logical formula that essentially returns the logical value FALSE. Microsoft says that the FALSE is kept in Excel for the sake of compatibility with other spreadsheet programs. You do not need to use in most cases, except for when using...
by Ilker | Aug 8, 2019 | Excel Formulas
The Excel TRUE function is a Logical formula that essentially returns the logical value TRUE. Microsoft notes that the TRUE function is included in Excel for compatibility with other spreadsheet programs. You do not need to use in most cases, except for when using...
by Ilker | Jul 29, 2019 | Excel Formulas
The Excel ERF.PRECISE (ERF PRECISE) function is an Engineering formula that calculates and returns the error function, integrated between a limit and zero (0). This function has been introduced Excel 2010, and is not available in earlier versions. However, the...
