Category: Functions

Functions

Excel MIN function

63 Views
The MIN function calculates the smallest value within a specified range of cells.  Only numerical values are accepted, given that …
Functions

Excel MAX function

92 Views
The MAX function calculates the largest value within a specified cell range.  Only numerical values are taken into account.  An …
Functions

Excel MEDIAN function

86 Views
The MEDIAN function calculates the median number within a specified range. What is the Median? Where there are an odd …
Functions

Excel AVERAGE function

156 Views
The AVERAGE function calculates the average (i.e. sum total divided by number of numbers) value within a specified cell range.  …
Functions

Excel OFFSET function

768 Views
The ‘OFFSET’ function in Excel will return a cell reference that is a given number of rows and columns away …
Functions

Excel COLUMNS function

67 Views
The ‘COLUMNS’ function in Excel will return the number of columns between a specified cell range.  For example, there are …
Functions

Excel COLUMN function

121 Views
The ‘COLUMN’ function in Excel will return the column number of a specified cell. Column A is returned as column …
Functions

Excel CELL function

680 Views
The ‘CELL’ function in Excel returns information about a specified cell. The information returned varies depending on the ‘info_type’ argument …