Microsoft Office Tutorials and References
In Depth Information
Logical Functions
Logical Functions
AND
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
this function.
FALSE
Returns a value if one condition is TRUE , and returns another value
if the condition is FALSE .
IF
Returns the reverse value of its arguments.
NOT
Returns FALSE if all arguments are false, and TRUE if all
arguments are true.
OR
Returns the value TRUE . There are no arguments associated with
this function.
TRUE
Lookup and Reference Functions
ADDRESS
Creates a cell address as text given specified row and column
numbers.
Returns the number of areas based on a reference.
AREAS
Returns the index number from the list based on a list of
arguments.
CHOOSE
Returns the column number based on a given reference.
COLUMN
Returns the number of columns based on an array or
reference.
COLUMNS
Searches for a specified value in an array or a table’s top row.
HLOOKUP
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.
HYPERLINK
Returns the value of an element selected by the row number and
INDEX
column letter indexes based on a table or array.
(Array Form)
Returns the reference of the cell based on the intersection of a
INDEX
particular row and column.
(Reference Form)
Returns the reference based on a text string.
INDIRECT
Looks in the first row or column of an array, and returns the
LOOKUP
specified value from the same position in the last row or column
of the array.
(Array Form)
Returns the value from the same position in a second row
LOOKUP
or column based on a range of one row or one column.
(Vector Form)
Search JabSto ::




Custom Search