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) |