View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dean[_8_] Dean[_8_] is offline
external usenet poster
 
Posts: 407
Default need a formula please

If you're asking how many combinations, it's K to the Nth power, where K is
the number of values each digit can be, and N is the number of digits. So,
for your case, it's 3-cubed or 27.

If each digit could be 0 thru 9, it would be 10-cubed or 1000. We know this
must be right because we know the number of integers between 0 and 999 (same
as between 1 and 1000)!

Dean

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
what's the formula for calculating all of the possible number combinations
in a given number?

so, if the number was 123, there would be 213,231, 321, 312 and so on.

just want to list them in 1 row.

thanks

--


Gary