SEARCH HOME
Math CentralQuandaries & Queries

search

Question from Marco, a student:

I need to generate in an Excel or other table all possible combinations for a set of 5 numbers with the following criteria:

1.- Numbers can repeat.
2.- Order does not matter.
3.- Numbers may be from 0-9
4.- The sum of all numbers is equal or less than 31.
5.- The sum of all numbers is equal or greater than 10.
6.- One of the numbers is 2.
7.- One of the numbers is 5.
8.- One of the numbers is 7.

Please Help

Sincerely,

Marco

Marco,

First off you can simplify your problem as follows:

Find two numbers

1.- The numbers, except 9, can repeat.
2.- Order does not matter.
3.- Numbers may be from 0-9
4.- The sum of the 2 numbers is equal or less than 17.

This should make it an easier task for you,

Penn

 

About Math Central
 

 


Math Central is supported by the University of Regina and The Pacific Institute for the Mathematical Sciences.
Quandaries & Queries page Home page University of Regina PIMS