# How to use the Financial Functions PRICE, PRICEDISC, PRICEMAT

Kornilios Ampatzis/ May 23, 2019/ Tutorials/ 0 comments

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.

# How to use the Financial Functions YIELD, YIELDDISC, YIELDMAT

Kornilios Ampatzis/ May 23, 2019/ Tutorials/ 0 comments

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

# How to use the Financial Functions ACCRINT, ACCRINTM

Kornilios Ampatzis/ May 23, 2019/ Tutorials/ 0 comments

Excel provides us with 2 functions for calculating accrued interest. ACCRINT, ACCRINTM.
But what exactly is accrued interest?

# The CELL Function

Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

It returns information about the formatting, location, or contents of a cell.

# The COUNTBLANK function

Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

The COUNTBLANK function provides us with a way to count the number of cells within a given cell range that are blank.

# The INFO Function

Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

It returns information about the current operating environment .

# The SUMIF Function

Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

It returns the sum of all the cells in a given range that meet a specific criterion.

# The COUNTIF Function

Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

It returns the number of cells of a given cell range that meet a specific criterion.

# The AVERAGEIF Function

Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

It returns the arithmetic mean (average) of all the cells in a given range that meet a specific criterion.

# The GETPIVOTDATA Function

Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

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.