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

Hour 15. Using Functions > Logical Functions

Logical Functions

Logical functions are used to create logical tests. A test enables a formula to make a decision based on particular data. A test can determine whether a value is greater than 25, and the formula making the test can perform one function if true, and another if false.

IF

The most common and useful logical function is the IF function, which allows you to develop several kinds of tests based on the operators used in the test statement. IF is often combined with other logical functions to create more specific tests. The syntax for the IF function looks like this:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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