Try the example, then check the result.
Download the fictional material and follow the steps below. The video uses English illustrative diagrams; it does not present a live app recording. Product controls may vary by version.
Check the answer before applying the method to your own data. How we review guides ↗
Watch the complete lesson.
The video uses English illustrative diagrams; it does not present a live app recording. English captions. Product menus may differ in your account.
Quick answer. For Open orders over 100, filter Status to Open and Amount to greater than 100; both criteria must hold. For Open OR Urgent, use a FILTER formula with a combined Boolean condition and verify the returned order IDs.
Use the fictional practice file and independent answer check. Work in a permitted copy.
Before you start. Import the fictional CSV into a copy of Google Sheets. Use its seven data rows and preserve the header. The table contains no real customer information.
1. Count the practice rows
Import the downloadable CSV as a new practice sheet. It has headers Order ID, Status, Amount, and Priority, followed by seven fictional orders. Read the answer check before filtering: the AND result should be orders one oh two, one oh five, and one oh seven.
Checkpoint: Seven fictional data rows.
2. Filter Status and Amount
Select the complete table including its header and create a filter. In the Status column, show only Open. In Amount, choose a greater-than-one-hundred condition. Column filters narrow the same row set, so this demonstrates AND: a visible row must satisfy both criteria.
Checkpoint: AND requires both conditions.
3. Check the AND IDs
The visible order IDs should be ORD-102, ORD-105, and ORD-107. ORD-101 is Open but only eighty dollars, so it should be absent. ORD-103 exceeds one hundred but is Closed, so it should also be absent. This negative check catches a filter applied to the wrong column.
Checkpoint: Three matching IDs only.
4. Use FILTER for an OR result
Clear the UI filters and use a separate output area for the OR result. FILTER can combine Boolean tests by adding them and checking whether the sum is greater than zero. For the seven practice rows, use the displayed formula; it checks Open in column B or Urgent in column D.
=FILTER(A2:D8,((B2:B8="Open")+(D2:D8="Urgent"))>0)Enter it in an empty output area, such as F2, so the result has room to spill. Do not put it inside A2:D8.
Checkpoint: Use the exact ranges A2:D8.
5. Compare the OR IDs
The OR result should contain ORD-101, ORD-102, ORD-104, ORD-105, and ORD-107. ORD-105 satisfies both conditions but should appear once. If the formula fails to parse, check your sheet's formula separators and range sizes; do not substitute the two-column UI filter for OR.
Checkpoint: Five unique order IDs.
Verify the result
AND (Open and amount > 100) returns ORD-102, ORD-105, and ORD-107. OR (Open or Priority = Urgent) returns ORD-101, ORD-102, ORD-104, ORD-105, ORD-107. Compare these IDs with the independent answer before using either result.
If it still does not work
A UI filter on two columns generally narrows rows by both conditions; it is not an OR rule. If the formula results differ, check the exact column references, header exclusion, and whether your spreadsheet locale uses a different formula argument separator.
Official sources
- https://support.google.com/docs/answer/3540681?hl=en
- https://support.google.com/docs/answer/3093197?hl=en
Any video panel without a marked actual-app capture is an illustrative diagram of the fictional exercise.
Practice downloads.
The exercise files contain invented information. Save a local copy before editing.