Combinations summing up to 100%

Could someone explain me how I can get in excel all the combinations of 3 variables with in an interval of 1%.
For example when there are 2 variables there are 11 combinations with an interval of 10%.

1.0 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0
0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0

Thanx in advance!

This will list the 5151 combinations. It uses whole numbers rather than decimals. but you can divide all the numbers by 100.

Please Login or Register  to view this content.

Thank you very much for providing me the code!

You're welcome