Basic AND function
BeginnerWhen a decision depends on multiple requirements, Excel can test them in one step.
The AND function returns TRUE only when every condition you give it is TRUE.
Syntax:=AND(logical1, logical2)
What you need to do
In this sheet, each sale has a Quantity and a Sale value ($). The minimum thresholds are listed in row 9:
- Minimum quantity is in B9
- Minimum sale value is in D9
Your goal is to fill the Meets both thresholds? column with TRUE or FALSE.
- Click cell D2.
- Start an AND formula with two logical tests:
- Test 1: Is the quantity in B2 at least the minimum quantity?
- Test 2: Is the sale value in C2 at least the minimum sale value?
- Use absolute references for the threshold cells (so the references to row 9 do not change when you copy the formula down).
- Press Enter. Cell D2 should show TRUE or FALSE.
- Copy the formula down from D2 through D7.
To copy down, select D2 and drag the small square at the bottom-right corner of the cell down to D7.
If you need more help with reference types, see the absolute vs relative references article.
Need some help?
Hint 1
"At least" means you should use >= (not just >) in each comparison.
Hint 2
When you reference the threshold cells, lock them as absolute references (for example, turn B9 into $B$9) so they do not shift when you copy down.
Hint 3
In D2, build AND with two logical tests: compare B2 to $B$9 and compare C2 to $D$9. Then fill the result down through D7.
Basic AND function
BeginnerWhen a decision depends on multiple requirements, Excel can test them in one step.
The AND function returns TRUE only when every condition you give it is TRUE.
Syntax:=AND(logical1, logical2)
What you need to do
In this sheet, each sale has a Quantity and a Sale value ($). The minimum thresholds are listed in row 9:
- Minimum quantity is in B9
- Minimum sale value is in D9
Your goal is to fill the Meets both thresholds? column with TRUE or FALSE.
- Click cell D2.
- Start an AND formula with two logical tests:
- Test 1: Is the quantity in B2 at least the minimum quantity?
- Test 2: Is the sale value in C2 at least the minimum sale value?
- Use absolute references for the threshold cells (so the references to row 9 do not change when you copy the formula down).
- Press Enter. Cell D2 should show TRUE or FALSE.
- Copy the formula down from D2 through D7.
To copy down, select D2 and drag the small square at the bottom-right corner of the cell down to D7.
If you need more help with reference types, see the absolute vs relative references article.
Need some help?
Hint 1
"At least" means you should use >= (not just >) in each comparison.
Hint 2
When you reference the threshold cells, lock them as absolute references (for example, turn B9 into $B$9) so they do not shift when you copy down.
Hint 3
In D2, build AND with two logical tests: compare B2 to $B$9 and compare C2 to $D$9. Then fill the result down through D7.