I. Intro
The OR function returns TRUE if one of the specified arguments meets the conditions, and returns FALSE if none of the specified arguments meet the conditions.
II. About the function
- Function formula: =OR(logical_expression1, [logical_expression2, ...])
- Parameters:
- Logical_expression1: A logical expression that will return either TRUE or FALSE.
- Logical_expression2: Additional expressions that evaluate to TRUE or FALSE.
- Example:
- =OR(A1=1, A2=2)
- Returns TRUE if the value in A1 equals 1 or the value in A2 equals 2. Returns FALSE if the value in A1 is not equal to 1 and the value in A2 is not equal to 2.
III. Steps
Use the OR function
- Select a cell and click Formula in the toolbar, then select Logical > OR. You can also directly enter =OR in a cell.
- Enter the parameters in the cell. Formula used below: =OR(B2="Red",C2="Sweet").
- Press Enter to display the result.
- Drag the + icon in the lower-right corner of the cell to apply the formula to more cells as necessary.
250px|700px|reset
Delete the OR function
Select the cell with the OR function and press Delete.
IV. Use cases
HR: Find the right candidate
The OR function can help HR quickly filter candidates with the right qualifications.
- Formula used below: =OR(B2="Master", C2="Over 1 year").
- About the parameters: The following conditions are set: Candidates with a "Master" in the "Degree" column and "Over 1 year" in the "Work Experience" column. TRUE will be returned if 1 of these 2 conditions is met, and the candidate qualifies for an interview.
250px|700px|reset