| Name: | COLUMN |
| Syntax: | COLUMN() |
| Description: | Returns the column that this function is in. The columns are numbered starting at zero. |
| Version: | 1.0 |
| Example: | COLUMN() If in A1, evaluates to 0 COLUMN() If in C10, evaluates to 9 |
| Name: | COLUMNS |
| Syntax: | COLUMNS(array) |
| Description: | Returns the number of columns in an array or reference. |
| Version: | 3.1 |
| Example: | COLUMNS(A1:D4) COLUMNS({1,2;3,4) |
| Name: | COUNT |
| Syntax: | COUNT(<args>[,<args>]*) |
| Description: | Returns the number of arguments passed in that are numbers. For range arguments, the number of number cells in the range is used. Value and reference arguments are treated as 1. |
| Version: | 1.0 |
| Example: | COUNT(1) Evaluates to 1 COUNT(1,2,3) Evaluates to 3 COUNT(A1:B3) Evaluates to 6 |
| Name: | COUNTA |
| Syntax: | COUNTA(<args>[,<args>]*) |
| Description: | Returns the number of arguments passed in that are not empty. For range arguments, the number of non-empty cells in the range is used. Value and reference arguments are treated as 1. |
| Version: | 3.0 |
| Example: | COUNTA(1) Evaluates to 1 COUNTA(1,2,3) Evaluates to 3 COUNTA(A1:B3) Evaluates to 6 |
| Name: | COUNTBLANK |
| Syntax: | COUNTBLANK(range) |
| Description: | Counts the empty cells in the specified range. |
| Version: | 3.1 |
| Example: | COUNTBLANK(A1) COUNTBLANK(A1:D4) |
| Name: | COUNTIF |
| Syntax: | COUNTIF(<range>, <criteria>) |
| Description: | Returns the number of cells in the first argument reference/range that match the criteria in the second argument. |
| Version: | 3.0.1 |
| Example: | COUNTIF(A1, ">0") COUNTIF(A1:C5, "a*") COUNTIF(A1:C5, "<>0") |
| Name: | ERROR.TYPE |
| Syntax: | ERROR.TYPE(error_type) |
| Description: | Returns a number corresponding to the type of error passed in: #NULL! 1 #DIV/0! 2 #VALUE! 3 #REF! 4 #NAME? 5 #NUM! 6 #N/A 7 Others #N/A |
| Version: | 3.1 |
| Example: | ERROR.TYPE(#REF!) |
| Name: | HLOOKUP |
| Syntax: | HLOOKUP(<value>,<array>,<number>[,<logical>]) |
| Description: | Returns the value of the cell in the column of the specified array whose first value matches the value passed in. If the 4th argument is true or omitted then an approximate value may match the first argument if the first argument is not less than the first value of the first column. Note that the values in the first row of the array must be sorted in ascending order, otherwise approximate matches may fail. |
| Version: | 1.2 |
| Example: | HLOOKUP(1,A1:B5,2) evaluates to the value of the cell in row 5 and column where the value in row 1 matches 1. |
| Name: | INDEX |
| Syntax: | INDEX(<array>, <row_num> [, <col_num>]) |
| Description: | Returns a value of the cell at the intersection of a particular row and column, in a given range. |
| Version: | 3.3 |
| Example: | INDEX(A1:A20, 2) INDEX(A1:G15, 3, 4) |
| Name: | ISBLANK |
| Syntax: | ISBLANK(value) |
| Description: | Returns true if value refers to an empty cell. |
| Version: | 1.3 |
| Example: | ISBLANK(A1) evaluates to TRUE if A1 is empty and FALSE otherwise. |
| Name: | ISERR |
| Syntax: | ISERR(value) |
| Description: | Returns true if value refers to any error value except #N/A. |
| Version: | 1.3 |
| Example: | ISERR(A1) evaluates to TRUE is A1 contains an error (except #N/A) and FALSE otherwise. |
| Name: | ISERROR |
| Syntax: | ISERROR(value) |
| Description: | Returns true if value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). |
| Version: | 1.3 |
| Example: | ISERROR(A1) evaluates to TRUE is A1 contains an error and FALSE otherwise. |
| Name: | ISEVEN |
| Syntax: | ISEVEN(<number>) |
| Description: | Returns TRUE if the number is even. |
| Version: | 3.3 |
| Example: | ISEVEN(1) |
| Name: | ISLOGICAL |
| Syntax: | ISLOGICAL(value) |
| Description: | Returns true if value refers to a logical value. |
| Version: | 1.3 |
| Example: | ISLOGICAL(A1) evaluates to TRUE is A1 contains a logicate value and FALSE otherwise. |
| Name: | ISNA |
| Syntax: | ISNA(value) |
| Description: | Returns true if value refers to the #N/A (value not available) error value. |
| Version: | 1.3 |
| Name: | ISNONTEXT |
| Syntax: | ISNONTEXT(value) |
| Description: | Returns true if value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.) |
| Version: | 1.3 |
| Name: | ISNUMBER |
| Syntax: | ISNUMBER(value) |
| Description: | Returns true if value refers to a number. |
| Version: | 1.3 |
| Name: | ISODD |
| Syntax: | ISODD(<number>) |
| Description: | Returns TRUE if the number is odd. |
| Version: | 3.3 |
| Example: | ISODD(1) |
| Name: | ISREF |
| Syntax: | ISREF(value) |
| Description: | Returns true if value refers to a reference. |
| Version: | 1.3 |
| Name: | ISTEXT |
| Syntax: | ISTEXT(value) |
| Description: | Returns true if value refers to text. |
| Version: | 1.3 |
| Name: | MATCH |
| Syntax: | MATCH(<lookup_value>, <lookup_array> [,<match_type>]) |
| Description: | Returns the relative position of an item in an array that matches a specified value in a specified order. |
| Version: | 3.3 |
| Example: | MATCH(1, A1:D9) MATCH("a", A1:D9, 0) |
| Name: | N |
| Syntax: | N(value) |
| Description: | Converts a non-number value to a number. |
| Version: | 3.0 |
| Example: | N(1) Evaluates to 1. N("2") Evaluates to 2. N(TRUE) Evaluates to 1. N(DATE(2009, 1, 1)) Evaluates to 39814. |
| Name: | NA |
| Syntax: | NA() |
| Description: | Returns the error value #N/A (value not avilable) |
| Version: | 3.3 |
| Example: | NA() |
| Name: | ROW |
| Syntax: | ROW() |
| Description: | Returns the row that this function is in. The rows are numbered starting at zero. |
| Version: | 1.0 |
| Example: | ROW() If in A1, evaluates to 0 ROW() If in C10, evaluates to 2 |
| Name: | ROWS |
| Syntax: | ROWS(<array>) |
| Description: | Returns the number of rows in a reference or array. |
| Version: | 3.3 |
| Example: | ROWS(a1:d6) ROWS({1, 2; 3, 4}) |
| Name: | T |
| Syntax: | T(value) |
| Description: | Returns the text argument if it is text and the empty string if it is not. |
| Version: | 3.0 |
| Example: | T("A") Evaluates to "A". T(1) Evaluates to "". |
| Name: | TYPE |
| Syntax: | TYPE(<value>) |
| Description: | Returns an integer representing the data type of a value. Number=1, text=2, logical value=4, error value=16, array=64. |
| Version: | 3.3 |
| Example: | TYPE(1) TYPE("a") |
| Name: | VLOOKUP |
| Syntax: | VLOOKUP(<value>,<array>,<number>[,<logical>]) |
| Description: | Returns the value of the cell in the row of the specified array whose first value matches the value passed in. If the 4th argument is true or omitted then an approximate value may match the first argument if the first argument is not less than the first value of the first row. Note that the values in the first column of the array must be sorted in ascending order, otherwise approximate matches may fail. |
| Version: | 1.2 |
| Example: | VLOOKUP(1,A1:B5,2) evaluates to the value of the cell in column B and row where the value in column A matches 1. |