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)