# Nested if formula problem

#### sitewolf

##### Active Member
So I'm trying to figure out a formula, not VBA, to determine if a basketball stat line includes a triple double.
In other words, a formula that looks at 5 different numbers and tells me if at least 3 of them are 10+
I've done nested ifs looking at the same number with multiple criteria, but I'm not wrapping my head around one that looks at multiple numbers with one criteria.

More specifically
Player A had 12 points, 10 rebounds, 12 assists, 3 steals, and 2 blocks
Player B had 23 points, 9 rebounds, 10 assists, 2 steals, and 2 blocks

What formula yields a 1 for Player A and 0 for Player B?

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### mrshl9898

##### Well-known Member
F2 =IF(COUNTIF(A2:E2,">="&10)>=3,"TRIPLE DOUBLE","")

#### Fluff

##### MrExcel MVP, Moderator
+Fluff v2.xlsm
ABCDEFG
1Name
2Player A121012321
3Player B23910220
Master
Cell Formulas
RangeFormula
G2:G3G2=N(COUNTIF(B2:F2,">=10")>2)

#### sitewolf

##### Active Member
Thank you both! I think I can get where I need to with either of these.

#### Fluff

##### MrExcel MVP, Moderator
Glad we could help & thanks for the feedback.

Replies
12
Views
242
Replies
4
Views
201
Replies
1
Views
490
Replies
3
Views
636
Replies
6
Views
154

1,128,069
Messages
5,628,468
Members
416,319
Latest member
k8o2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back