Zend certified PHP/Magento developer

What is the formula for permutations and combinations in excel

I have a range of numbers 1,2,3,4
What is the formula to combine this in excel?

The results will be 1 – four folds, 4 – three folds and 6 – two folds

Example of possibilities :

  • 1,2,3,4
  • 1,2,3
  • 1,2,4
  • 1,3,4
  • 2,3,4
  • 1,2
  • 1,3
  • 1,4
  • 2,3
  • 2,4
  • 3,4

I think it is called yankee in betting