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

Chapter 12. Building Formulas > Creating Conditional Tests

Creating Conditional Tests

A conditional test formula compares two numbers, functions, formulas, labels, or logical values. Conditional tests can be used to flag values that fall below or above a given threshold, for example. You can use simple mathematical and logical operators to construct logical formulas, or you can use an assortment of built-in functions. For information about using conditional test functions, see “Understanding Logical Functions” on page 421.

Each of the following formulas performs a rudimentary conditional test:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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