Logical Operations

Sir Tom taught us about Logical Operations.

• AND(logical1,logical2,...) tests whether the logical arguments are TRUE or FALSE. If they are all TRUE, the AND function returns TRUE to thecell. If any are FALSE, the AND function returns FALSE.
• IF(logical_test,value_if_true,value_if_false) tests whether thelogical_test expression is TRUE or FALSE. If TRUE, the IF function returns the value_if_true argument. If FALSE, the IF function returns thevalue_if_false argument.
• NOT(logical) tests whether the logical argument is TRUE or FALSE. If TRUE, the NOT function returns FALSE. IF FALSE, the NOT function returns TRUE.
• OR(logical1,logical2,...) tests whether the logical arguments are TRUE or FALSE. If any are TRUE, the OR function returns TRUE. If all are FALSE, the OR function returns FALSE.
• FALSE() takes no argument and simply enters logical FALSE in its cell.
• TRUE() takes no argument and simply enters logical TRUE in its cell.

Example: