Manuals/calci/COMBIN

COMBIN(n,r)


  • is the number of items.
  • is the number of items in each arrangement.

Description

  • This function gives the combination of   objects.
  • i.e An arrangement of   objects without any repetition, selected from   different objects is called a combination of   objects taken   at a time.
  • If the order is not a matter, it is a Combination.
  • If the order is a matter it is a Permutation.
  • A combination is denoted by nCr or  .
  • A formula for the number of possible combinations of   objects from a set of   objects is   where   &  .
  • This function will give Error Result when
  1. The   &   are non numeric
  2. The   &   or  
  • When we are giving the   &   values in decimals, it will automatically convert into Integers.
  • For e.g.
    • COMBIN(5.4,2)=10 is equivalent to COMBIN(5,2)
    • COMBIN(5,-2)=NAN, because   is negative.

ZOS Section

  • The formula to calculate COMBINATION in ZOS is  
    •   is the number of items.
    •   is the number of items in each arrangement.

Examples

COMBIN(n,r) n r RESULT
COMBIN(12,3) 12 3 220
COMBIN(4,4) 4 4 1
COMBIN(4,0) 4 0 1

See Also

References

Combination