# How to check if all values in a range meet a condition in Excel

Test the weakest value: =IF(MIN(B2:E2)>=$I$1,"Passed all","Retake"). If the lowest score passes, they all do.

**Excel:** `=IF(MIN(B2:E2)>=$I$1,"Passed all","Retake")` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F | G | H | I |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Student | Test 1 | Test 2 | Test 3 | Test 4 | Result |  | Pass mark | 60 |
| Ava | 72 | 65 | 80 | 61 |  |  |  |  |
| Ben | 58 | 77 | 69 | 90 |  |  |  |  |
| Cleo | 60 | 60 | 75 | 82 |  |  |  |  |
| Dan | 88 | 91 | 59 | 94 |  |  |  |  |
| Eve | 66 | 71 | 68 | 74 |  |  |  |  |
| Finn | 45 | 52 | 61 | 58 |  |  |  |  |

Formula in F2, filled to F7: `=IF(MIN(B2:E2)>=$I$1,"Passed all","Retake")`

Result: Passed all; Retake; Passed all; Retake; Passed all; Retake

## How it works

"All at least 60" is the same as "the lowest is at least 60", so MIN reduces four tests to one. Cleo's two 60s meet the mark exactly. For a condition that isn't a number threshold, count the cells that fail instead (see the alternatives).

## Other ways

- `=IF(COUNTIF(B2:E2,"<"&$I$1)=0,"Passed all","Retake")`: No failing cells means all pass. This pattern works for any COUNTIF condition, including text.
- `=IF(AND(B2:E2>=$I$1),"Passed all","Retake")`: AND over a range. Excel 365 and 2021 evaluate it directly; Google Sheets needs ARRAYFORMULA.

## Common mistakes

- MIN and COUNTIF skip empty cells, so a missing test looks like a pass. Add `COUNT(B2:E2)=4` to the test if every score is required.
- Scores stored as text are ignored by MIN. Convert the column to numbers first.

## Questions

**How do I check that every cell says Yes?**

Compare the count with the number of cells: `=COUNTIF(B2:E2,"Yes")=COLUMNS(B2:E2)`.

**How do I check that all cells are filled in?**

Use `=COUNTBLANK(B2:E2)=0`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/if-all-values-meet-a-condition