Manuals/calci/COMBIN

From ZCubes Wiki
Jump to navigation Jump to search
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

Combination
  • The formula to calculate COMBINATION in ZOS is or
    • 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