The CELL Function
It returns information about the formatting, location, or contents of a cell.
0305, 2019
Category Archives: Functions
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.
0305, 2019
The SUMPRODUCT Function
It returns a number rounded down, to the nearest integer .
0305, 2019
The PRODUCT Function
It multiplies all the numbers given to it as arguments and returns the product.
0305, 2019
The INT Function
It returns a number rounded down, to the nearest integer .
