Microsoft Office Tutorials and References
In Depth Information
Returns TRUE if the arguments are true in the formula, and FALSE
if they’re false.
Returns the value FALSE . There are no arguments associated with
Returns a value if one condition is TRUE , and returns another value
if the condition is FALSE .
Returns the reverse value of its arguments.
Returns FALSE if all arguments are false, and TRUE if all
arguments are true.
Returns the value TRUE . There are no arguments associated with
Lookup and Reference Functions
Creates a cell address as text given specified row and column
Returns the number of areas based on a reference.
Returns the index number from the list based on a list of
Returns the column number based on a given reference.
Returns the number of columns based on an array or
Searches for a specified value in an array or a table’s top row.
Creates a shortcut to jump to a document stored within a
workbook or on a network ser ver. You can also use the hyperlink
function to link to a URL, such as a stock page on the Web.
Returns the value of an element selected by the row number and
column letter indexes based on a table or array.
Returns the reference of the cell based on the intersection of a
particular row and column.
Returns the reference based on a text string.
Looks in the first row or column of an array, and returns the
specified value from the same position in the last row or column
of the array.
Returns the value from the same position in a second row
or column based on a range of one row or one column.