multiplication of 3 sets

[new exceler]

hello every body
i want to calculate all possible results of multiplication of 3 sets: a,b,c with the same members :{1,2,3,4,5,6,7,8,9,10}
in excel ? that is how can i caculate all members of the set m ={a*b*c} in excel?
thanks

 

[XOR LX]

For another set instead of 1-10, for ex. if the elements are 1-5 or 1-8, in my formula one just replaces the 10 with the upper bound of the interval.

Agreed. It's a nice, flexible construction. I've used it in other situations, e.g. for generating such permutations within arrays, though I didn't see an application for it here until I saw your post.

Cheers