WPS logical Operators

1.AND

Purpose: Returns True when the logical value of all parameters is true (true), or False (false) as long as the logical value of one parameter is false.

Syntax: and (logical value 1, logical value 2,⋯).

Parameters: Logical value 1, logical value 2,⋯ as 1~30 logical expression to be checked, their conclusion is true (true) or False (false). The argument must be a logical value or an array or reference that contains logical values, and if the array or reference has text or blank cells, its value is ignored. If the specified range of cells contains a non logical value, and the error value #value! is returned.

Instance: If a1=2, A 2 = 6, then the formula "=and (A1A2)" returns True.

2.FALSE

Purpose: Returns the logical value FALSE.

Syntax: FALSE ()

Parameter: The function does not require arguments

Instance: If you enter the formula "=false ()" In the A1 cell, return to FALSE after the carriage return. If you enter false text in a cell or formula, the WPS table automatically interprets it as a logical value false.

3.IF

Purpose: To perform logical judgments, which can return different results depending on the true and false of the logical expression, thus performing the conditional detection task for the numeric or formula.

Syntax: IF (logical_test,value_if_true,value_if_false).

Parameters: Any numeric or expression in which the test condition evaluates to TRUE or FALSE, or true if the value of the function returns when the test condition is true and if the test condition is true and the truth is omitted. And the truth value can be an expression; the false is the return value of the function when the test condition is false. Returns false if the test condition is false and the false value is omitted. A false value can also be an expression.

Instance: Formula "=if" (c2>=85, "A", if (c2>=70, "B", if (c2>=60, "C", if (c2<60, "D")) ", where the second if statement is also the argument of the first if statement. Similarly, the third if statement is the argument for the second if statement, and so on. For example, if the first logical judgment expression is c2>=85, the D2 cell is assigned A value of "A", and if the first logical judgment expression c2>=85 is not true, the second if statement "if" (c2>=70) is computed, and so on until the end of the calculation, This function is widely used in situations where logical judgment is required.

4.NOT

Purpose: To find the opposite value of a logical value or logical expression. If you want to make sure that a logical value is equal to its opposite value, you should use the NOT function.

Syntax: Not (logical value)

Argument: Logical value is a logical value or logical expression that can draw a true or false conclusion. If the logical value or expression evaluates to False, the NOT function returns True, and if the logical value or expression evaluates to True, then the NOT function returns FALSE.

Instance: If a1=6, a2=8, then the formula "=not (a1< A2)" returns false