Solvingcorner

Level Easy
Ver Excel 2000 or above

Microsoft Excel has built in Logic Function like NOT, AND, OR. Observe the picture below.

Excel Logics

Look at Cell D5, the formula is =NOT(A5>60). Cell A5 is NOT smaller than 60. Is it True? TRUE

Look at Cell D6, the formula is =AND(A6<=50,B6>=70). While B6<=70 = TRUE, A6<=65 = FALSE. Because the operator is AND, if both values in bracket returns TRUE, the result would be TRUE. But if one of the value returns FALSE, the result would be FALSE. If both returns FALSE, the result also FALSE.

Look at Cell D7, the formula is =OR(A7>60,B7<=50). Only one of the values returns TRUE. So the result is TRUE. With OR operator, if one of the value returns TRUE then the results would be TRUE. If both values return FALSE, the results also FALSE.

These Logical Operation will be useful to build simple worksheet automation.