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

Advertisements

3 Responses to Conditional Formulas for the Calculated Column

  1. Pingback: Date and Time Information for the Calculated Column « SharePoint Diva

  2. Pingback: Text Formulas for the Calculated Column « SharePoint Diva

  3. Pingback: Mathematical Information for the Calculated Column « SharePoint Diva

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: