If the cell value is greater than 0 and less than 1:
Success is 100 times cell value
Trials is 50
Population size is 100
If the cell value is between 2 and the maximum number of Hypergeometric trials (1,000):
Success is cell value divided by 2 (rounded downward)
Trials is cell value divided by 2 (rounded downward)
Population size is cell value
Otherwise:
Sucess is 50
Trials is 50
Population size is 100