the COMBINE function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


Welcome back to our usual blog of Excel functions from A to Z. Today we look at the COMBINE function.

The COMBINE function

This function returns the number of combinations (with repetitions) for a specified number of items. If this seems a bit confusing, think of it this way: has a number balls in the bag, each with a different number. You draw a ball at random, you register her number and then replace it. you did this chosen_number times. Ignoring the sequence of the selected numbers, COMBINE deduce the number of different combinations. Since there is replacement, chosen_number can exceed the number what's more.

As an example, the selection of three numbers from a bag of balls numbered from the 1 al 4 I would have the following 20 combinations:

111, 112, 113, 114, 122, 123, 124, 133, 134, 144, 222, 223, 224, 233, 234, 244, 333, 334, 344 Y 444.

The COMBINE The function uses the following syntax to operate:

COMBINE (number, chosen_number)

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.