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

Specifying Criteria

No matter which of the three methods of finding or filtering data you use, you need to learn how to specify the data you want to find. The specifications for what you want to find are called criteria. Criteria can be in many forms. It can be simply a name, such as John, or a comparison, such as Amounts>500; or it can involve a calculation, such as =AND(B12>500,B12<1000).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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