sitewolf
Active Member
- Joined
- May 4, 2012
- Messages
- 304
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?
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?