gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 346
- Office Version
- 365
- Platform
- Windows
- Mobile
Hi, I'm looking for a formula that uses random numbers that will sum to a predetermined number. For example, if the predetermined number is 15, one iteration might look like: 2+3+1+5+5 = 15, second iteration: 5+1+6+2+1=15, etc.
That's the basic idea, but if additionally it could be constrained to always use a certain number of variables as well, that would be great. The two examples above use 5 numbers that always will equal the predetermined number.
That's the basic idea, but if additionally it could be constrained to always use a certain number of variables as well, that would be great. The two examples above use 5 numbers that always will equal the predetermined number.