Formulas > =POISSON.DIST()

How To Use POISSON.DIST() Function in Google Sheets


Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.

Common questions about the POISSON.DIST formula include:

• What is the purpose of the POISSON.DIST formula? 
• How is the POISSON.DIST formula calculated? 
• How many arguments does the POISSON.DIST formula accept? 
• What is the syntax for the POISSON.DIST formula?

The POISSON.DIST formula can be appropriately used to calculate the probability of a certain number of successes occurring in a given time interval. It accepts three arguments: the number of successes, the expected mean number of successes, and a cumulative probability (or the “cumulative” argument). The syntax for the POISSON.DIST formula is POISSON.DIST(x, mean, cumulative).

The POISSON.DIST formula can be commonly mistyped as POISON.DIST, POISSONS.DIST and POISSONS.DIST. It can also be mistyped in regards to the order of the arguments, as the arguments must be accepted in the order of x, mean, and cumulative.

The POISSON.DIST formula may be used inappropriately if the mean argument is incorrectly specified or given a value greater than 1. Also, forgetting to use a logical value for the cumulative argument (TRUE or FALSE) can lead to an incorrect result. 

Some common pitfalls when using the POISSON.DIST formula include incorrect specification of the arguments (either mistyped or forgotten), incorrectly specifying the mean argument, and forgetting to enter a logical value for the cumulative argument.

Common mistakes when using the POISSON.DIST formula include mistaking the arguments, omitting arguments, misplacing the arguments, and incorrect specification of the mean argument. 

Common misconceptions people might have with the POISSON.DIST Formula include confusing the formula with another type of statistical or probability function, forgetting to specify the cumulative argument as either TRUE or FALSE, and thinking that it is used to calculate a summary statistic such as a mean or median.

How To Actually Use POISSON.DIST() in Sheets

POISSON.DIST(x, mean, [cumulative])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the POISSON.DIST() formula:

Google Sheets POISSON DIST Probability Mass or Cumulative Distribution Function ARRAYFORMULA

This video shows the use of ARRAYFORMULA to generate Google Sheets Poisson Probability Mass and Poisson Cumulative Distribution Function.

Generate a POISSON.DIST() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.