# Check a Box if Values Greater than 2 appear in any cell in a row

I've seen many posts about box check =IF formulas, but they all reference specific columns in brackets. Is there a formula I could use @row that would search the entire row for numbers greater than 2 and check a box if there is a number greater than 2?

Thank you! This helps flag when the workforce has been overscheduled.

Tags:

• ✭✭✭✭✭
```=IF(COUNTIF([3/25/24]@row:10/5/24@row, >2), 1, 0)
```

...

• ✭✭✭✭✭

You can do a combination of IF Statement and OR function.

```Status =
=IF(OR(
A@row > 2, B@row > 2, C@row > 2, D@row > 2),
1, 0)
```

...

• This is very helpful and almost gets me there. Could I put in a range of columns as well? We have 350 columns.

• ✭✭✭✭✭

For column range, you can use `[Column Name:Column Name]`. Or if you mean to apply the function to the entire row, you can convert the it to a column formula.

...

• This is very close, but it comes back as Unparseable. Here's the formula I'm using:

• ✭✭✭✭✭
```=IF(COUNTIF([3/25/24]@row:10/5/24@row, >2), 1, 0)