Select Page

Excel STDEV.P Function

The Excel STDEV.P function is a Statistical formula that calculates and returns the standard deviation for the entire population of data. The standard deviation is a measure of how much values are dispersed from the mean of a data set. The STDEV.P calculates the...

Use the ERROR.TYPE to Identify Excel Errors

The ERROR.TYPE function is an Information formula that returns an index number corresponding to a specific error value in Microsoft Excel. If there are no errors in the target cell(s), the function returns another error value, #N/A. This function can be especially...

Function: NOMINAL

The Excel NOMINAL function is a Financial formula that calculates and returns the nominal annual interest rate, for a given effective annual interest rate and number of compounding periods per year. The nominal annual interest rate is used for calculating financial...

Excel EFFECT Function

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...

Function: DURATION

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...

Excel YIELD Function

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...

Function: PRICEMAT

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...

Function: PRICEDISC

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....

Function: PRICE

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...