Factorials and Combinations

EasySpreadsheet includes functions to generate factorials and combinations.

FACT (number): Returns the factorial of the number. For example, the factorial of 6 is 6*5*4*3*2*, or 720. If number is a decimal number, it will be rounded down to the nearest integer. Note that number must be greater than or equal to 0.

COMBIN (number1, number2): Returns the number of ways a group of number2 items can be chosen from a group of number1 items. For example, COMBIN(6, 3) would return the number of ways a group of three could be chosen from a group of six. Note that number1 and number2 must be nonnegative, and number2 cannot be greater than number1.

Examples:

Formula

Result

=FACT(0)

1

=FACT(6.6)

720

=FACT(-1)

#NUM! (number cannot be negative)

=COMBIN(3, 2)

3

=COMBIN(3, 3)

1

=COMBIN(1, 2)

#NUM! (number2 cannot be larger)