COMBIN Function

The COMBIN function calculates the maximum number of combinations that can be formed with the given set of data. It calculates based on the total number of items and the size of a group.
However, it does not consider the order of the combination. Ex: AB is same as BA.

Formula:


=COMBIN(Number of items, Group Size)

Video Tutorial:


Let us learn to find the possible combinations of numbers, using COMBIN function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question