HYPGEOMDIST(x NSample Successes Npopulation Cumulative) function fails to calculate cumulative probability (Cumulative=1) for situations where part of the individual mass functions are too small and gives out "Err:502" What the function should do is to equate those values to zero or do not consider them when adding Pr(X=0) + Pr(X=1) +