In order to fit the costumes, the new guy must be 68 to 69 inches tall, must weigh between 180 and 200 pounds, and must be aged between 30 and 50. For example: One of the actors in GeorgeвЂ™s play broke his leg, so George needs another actor, immediately, with very specific skills and appearance. When youвЂ™re trying to find something that meets multiple criteria, AND is your operator.

When combined with other functions, however, such as IF statements, you can create some complex formulas that produce very powerful results. Excel 2013 allows a maximum of 255 arguments in a single logical function, but only if the formula does not exceed 8,192 characters.Д«oolean operators may start out looking simple.When youвЂ™re searching for a range of results via Boolean operators, you define the range by what itвЂ™s more than or less than.=XOR(5+1=2, 5-1=2) returns FALSE because both conditions are false =XOR(1+1=2, 2-1=1) returns FALSE because both conditions are true XOR вЂ“ also called Exclusive OR, returns true if either argument (but not both) is trueД®xamples: =XOR(1+1=2, 2-1=2) returns TRUE because one condition is true and one is false NOT вЂ“ returns true if condition specified is NOT met (reverse logic)Д®xample: =NOT(100>500) TRUE because 100 is NOT greater than 500 OR вЂ“ returns TRUE if at least one of the specified conditions is trueД®xample: =OR(100 300) TRUE because one of the conditions is true The simplest definition for each operator is this:ДЄND вЂ“ returns TRUE if all conditions specified are trueД®xample: =AND (100 100) TRUE because both conditions are true These operators are used between search terms to narrow, expand, or exclude your results in databases, spreadsheets, search engines, or any situation where youвЂ™re seeking specific information. The reason to bone up on Boolean logic is because itвЂ™s a method you can use in other applications, like search engines and databases.Д«oolean operators, which Excel calls logical functions, include AND, OR, NOT, and a new function called XOR. Granted, there are other ways to search a spreadsheet, including Lookup functions and pivot tables. In Excel, Boolean logic (a fancy name for a simple condition thatвЂ™s either true or false) is one way to sift specific data or results from a large spreadsheet. Excel logical functions make it easy to find the data you want, especially in huge spreadsheets.

Excel if and