Logical Functions: OR
The OR function answers True if ANY of the conditions
are
true. The OR function will only return FALSE if ALL of the logical
arguments are FALSE. This is Conditional Logic.
1.
Try it: Create a Logical Formula
Select
Cell F1 and type: Little Pay in 60.
Select
Cell F1 and format the label BOLD.
Select
Cell F2.
Go to
Formulas->Function Library ->Logical.
Click on
OR.
What Do
You See? Microsoft Excel will prompt you to fill in the
Arguments.
Logical1: C2<60
Logical2:
B2<5000
2. Fill Down the Formula
Select: Cell F2.
Autofill the equation in Cells F3:F5.
The answer should be TRUE or FALSE.