NEGBINOMDIST function

Category: Compatibility
Introduced: Excel 365

Summary

Returns the negative binomial distribution

Syntax

NEGBINOMDIST(number_f,number_s,probability_s) The NEGBINOMDIST function syntax has the following arguments:
• Number_f Required. The number of failures.
• Number_s Required. The threshold number of successes.
• Probability_s Required. The probability of a success.

Example

=NEGBINOM.DIST(A2,A3,A4,TRUE)
=NEGBINOM.DIST(A2,A3,A4,FALSE)

Microsoft Support Page

https://support.microsoft.com/en-us/office/negbinom-dist-function-c8239f89-c2d0-45bd-b6af-172e570f8599

Back to Functions