How to use the Financial Functions PRICE, PRICEDISC, PRICEMAT
In order to be able to calculate the price per $100 face value we pay for an investment, Excel provides us with 3 tools.
The functions PRICE, PRICEMAT, PRICEDISC.
2305, 2019
Monthly Archives: May 2019
2305, 2019
How to use the Financial Functions YIELD, YIELDDISC, YIELDMAT
Excel provides us with numerous functions to calculate and manage securities.
Let’s start with the functions that calculate the Yield of a security. These are YIELD, YIELDMAT and YIELDDISC
2305, 2019
How to use the Financial Functions ACCRINT, ACCRINTM
Excel provides us with 2 functions for calculating accrued interest. ACCRINT, ACCRINTM.
But what exactly is accrued interest?
0305, 2019
The CELL Function
It returns information about the formatting, location, or contents of a cell.
0305, 2019
The COUNTBLANK function
The COUNTBLANK function provides us with a way to count the number of cells within a given cell range that are blank.
0305, 2019
The INFO Function
It returns information about the current operating environment .
0305, 2019
The SUMIF Function
It returns the sum of all the cells in a given range that meet a specific criterion.
0305, 2019
The COUNTIF Function
It returns the number of cells of a given cell range that meet a specific criterion.
0305, 2019
The AVERAGEIF Function
It returns the arithmetic mean (average) of all the cells in a given range that meet a specific criterion.
0305, 2019
The GETPIVOTDATA Function
It returns data stored in a PivotTable. You can use GETPIVOTDATA to retrieve summary data from a PivotTable, but only if the summary data is visible in the report.
