{oapdf_gg}
one, AND, OR, NOT function These three functions are used to return to the logic of the value of parameters. Details see below: (A) AND function The logic of the value of all the parameters for the true return TRUE; as long as the logic of a parameter value of false returned FALSE. In short, that is, when the AND of the parameters of a particular condition is met in full and return to the results of TRUE, otherwise FALSE. Syntax for the AND (logical1, logical2, ...), which Logical1, logical2, ... said to be testing the conditions of 1-30 value, the value of the condition may be TRUE, may be FALSE. Parameter must be a logical value, or value contains an array of logic or quote. Example: 1, in cell B2, type the number 50, write the formula in C2 in the = AND (B2> 30, B2 <60). B2 is indeed equal to 50 as a result of more than 30, less than 60. Therefore, the value of the two conditions (logical) are true, then return to the results of TRUE. OR function means the State in the parameter group, the logic of any one parameter value is TRUE, return TRUE. It is the difference between the AND function, AND function logic function requires that all values are true, the results for the real side. OR function and only any one of them can be true is true. For example, the above Example 2, if cell B4 to write the formula for the = OR (B1: B3) is equivalent to TRUE results Figure 3 OR function example (c) NOT function NOT function for the parameter values for the anti-. When a value to ensure that does not mean that a particular value, you can use the NOT function. In short, that is, when the parameter value of TRUE when, NOT function returns the result of exactly the opposite result, for FALSE. For example, NOT (2 +2 = 4), as a result of 2 +2 is indeed the result of 4, the results of the parameter TRUE, because it is NOT a function of the return of function, therefore the results of In contrast, for FALSE. |