Help with conditional/additive permutations?

Occasional Visitor

Hello! First post here, so apologies for any faux pas.

I'm trying to get a formula that does the following:

  1. There are (3) possible values: 5, 6, and 7
  2. There are (5) possible slots, that is: 7*5, 7*4+6*1. 7*4+5*1, 7*3+6*2, etc.
  3. Essentially the formula should return all possible combinations (35, 34, 33, etc.).

Any tips or tricks? I can't seem to get it working. 



1 Reply

@PatsIt Your asking for the sum of all possible combinations, so the highest possible sum would be 5 x 7 = 35 and lowest possible sum would be 5 x 5 = 25. Any combination of fives, sixes and sevens will add up to a number in this range.

If you are an MS365 subscriber, you could use SEQUENCE like this:

Screenshot 2021-11-13 at 07.39.14.png