need help finding a number combo.

  • Thread starter Thread starter PDUTCHY
  • Start date Start date
P

PDUTCHY

If I have a keypad with numbers from 1 to 9, how many 3 digit numbe
combos can I get using any 3 numbers in any order....

123
456
789

that is the keypad...

THANKS!
 
Hi
if you allow repeating digits (e.g. 999) then
=9^3 combinations (not allowing zero)

without duplicates you have
=9*8*7 combinations
 
PDUTCHY

The PERMUT Function is useful in these cases.

=PERMUT(9,3) returns 504 as Frank's "no duplicates" shows.

Gord Dibben Excel MVP
 
Back
Top