Conditional Formulas for the Calculated Column

This is a continuation of an attempt to group the information needed for Calculated Columns in a meaningful way. Some items appear on more than one list since this exercise can be subjective.

Examples of common formulas: Conditional formulas

Other Conditional Functions:

AND function	Returns the logical value TRUE if all of the arguments are TRUE; returns FALSE if one or more arguments is FALSE.
CHOOSE function	Uses index_num to return a value from the list of value arguments.
COUNT function	Counts the number of arguments that contain numbers.
COUNTA function	Counts the number of arguments that are not empty.
EXACT function	Compares two text strings and returns the logical value TRUE if they are exactly the same, FALSE otherwise.
FALSE function	Returns the logical value FALSE.
IF function	Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
ISBLANK	Value refers to an empty column reference.
ISERR	Value refers to any error value except #N/A.
ISERROR	Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISLOGICAL	Value refers to a logical value.
ISNA	Value refers to the #N/A (value not available) error value.
ISNONTEXT	Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank column reference.)
ISNUMBER	Value refers to a number.
ISTEXT	Value refers to text.
NOT function	Reverses the value of its argument.
OR function	Returns Yes if any argument is TRUE; returns No if all arguments are FALSE.
T function	Returns the text referred to by value.
TRUE function	Returns the logical value TRUE.

Date and Time Information for the Calculated Column

Text Formulas for the Calculated Column

Conditional Formulas for the Calculated Column

Mathematical Information for the Calculated Column