Support / SharePoint / SharePoint Server / SharePoint Server 2007 Help and How-to / Business intelligence / Business data in sites, lists, and libraries / Formulas and functions

Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

Logical

AND function

Article Returns the logical value TRUE if all of the arguments are TRUE; returns FALSE if one or more arguments is FALSE. Syntax AND ( logical1 , logical2 , .....

FALSE function

Article Returns the logical value FALSE. Syntax FALSE ( ) Remark You can also type the word FALSE directly into the formula, and it is interpreted as the logical...

IF function

Article Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct conditional tests on values...

NOT function

Article Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value. Syntax NOT ( logical ) Logical is...

OR function

Article Returns Yes if any argument is TRUE; returns No if all arguments are FALSE. Syntax OR ( logical1 , logical2 , ... ) Logical1, logical2,... are 1 to 30...

TRUE function

Article Returns the logical value TRUE. Syntax TRUE () Remark You can enter the value TRUE directly without using this function. The TRUE function is provided primarily...