• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VIII: Appendixes > Logical Functions

Logical Functions

Boolean algebra is based on a simple set of logical statements. For example, if value A is true and value B is true, the AND function will return true. You can use these types of logical functions to perform similar tests, and your functions can then provide some result based on whether a logical test is true or false. Table B.5 details the logical functions within Excel.

Table B.5. Logical Functions in Excel
Function SyntaxReturns
=AND(logical1,logical2,…)TRUE if all arguments are true, or FALSE if any argument is false
=FALSE( )The logical value FALSE
=IF(logical_test,value_if_true,value_if_false)Provides one of two results that you specify, based on whether the test evaluates to TRUE or FALSE
=NOT(logical)Reverses a logical value; TRUE becomes FALSE and vice versa
=OR(logical1,logical2,…)TRUE if any argument is true, or FALSE if all arguments are false
=TRUE( )The logical value TRUE



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint