COMBINA |
COMBINA(number, number_chosen) |
Returns the number of combinations for a given number of items (with repetition). |
number | The total number of items. |
number_chosen | The number of items in each combination. |
REMARKS |
* Added in Excel 2013. * If "number" < 0, then #NUM is returned. * If "number" < "number_chosen", then #NUM is returned. * If "number_chosen" < 0, then #NUM is returned. * If "number" is not an integer, it is truncated. * If "number_chosen" is not an integer, it is truncated. * If you want to return the number of combinations (without repetition) you can use the COMBIN function. * For the Microsoft documentation refer to support.microsoft.com |
|
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top