| | | If any of the arguments are not numeric, then #VALUE! is returned. |
| | | If "number" is not an integer, it is truncated. |
| | | If "number" < 0, then #NUM! is returned. |
| | | If "number_chosen" is not an integer, it is truncated. |
| | | If "number_chosen" < 0, then #NUM! is returned. |
| | | If "number" < "number_chosen", then #NUM! is returned. |
| | | A combination is any set or subset of items, regardless of their internal order. |
| | | Combinations are distinct from permutations, for which the internal order is significant. |
| | | Example 1 - How many different 2 person teams can be made up from 8 people. answer 28 teams. |
| | | Example 2 - How many combinations are there for a padlock with 3 numbers, answer 1,000 possibilities. |