P(X = x) in Excel: Calculate an Exact Probability

To find an exact probability P(X = x) for a binomial variable in Excel, use BINOM.DIST with its cumulative argument set to FALSE. With the number of trials in B1, the probability of success on each trial in B2, and the target number of successes in B3, enter =BINOM.DIST(B3,B1,B2,FALSE). This returns the chance of getting exactly the count in B3. The steps below explain how to set up the inputs, read the result, and handle other meanings of P(X = x).

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The formulas shown also work in Excel for Mac and Excel for the web.
A clearly defined random variable X, a target value x, and the distribution or probability model that applies.
For the binomial example, a number of trials and a success probability between 0 and 1. The probability must be the same on each trial, and trials must be independent.

Step-by-Step

Decide what X represents. In a binomial problem, X counts how many times an event called a success occurs across a fixed number of independent trials. For example, X might be the number of defective items in a sample of ten, the number of correct answers in a quiz, or the number of customers who respond to an offer. Define success for your question; it does not have to mean a desirable outcome. If your trials are not independent, the success chance changes from trial to trial, or you are measuring a continuous quantity, the binomial formula may not fit.
Put the binomial inputs in cells. For this example, enter 10 in B1 for the number of trials, 0.3 in B2 for the probability of success on each trial, and 4 in B3 for the exact count you want. The value 0.3 means a 30% chance on each trial. You can add labels in A1:A3, such as Trials, Success probability, and Target successes, so the workbook is easier to check later. Enter the probability as 0.3 or 30%, not as the number 30.
Calculate the exact probability. With trials in B1, success probability in B2, and the target count in B3, enter =BINOM.DIST(B3,B1,B2,FALSE) in B4. Press Enter. With the example inputs, Excel returns 0.200120949, approximately 20.0121%. This means that under the stated assumptions, the chance of exactly four successes in ten trials is about 20.01%. Excel returns a decimal probability; multiplying by 100 or applying percentage formatting displays it as a percentage.
Check the function arguments. The order is target number of successes, number of trials, probability of success, and cumulative. The final argument FALSE requests the probability of exactly the target count. If you leave that argument out, Excel requires you to supply it; include FALSE or TRUE explicitly so the result is unambiguous. The function is named BINOM.DIST in current Microsoft 365 Excel.
Calculate a cumulative probability when that is what the question asks. A question such as “four or fewer” means P(X ≤ 4), not P(X = 4). With the same inputs in B1:B3, enter =BINOM.DIST(B3,B1,B2,TRUE). TRUE adds the probabilities for zero, one, two, three, and four successes. For “more than four,” subtract that cumulative result from 1, or ask for the complement of the appropriate cumulative count. Read words such as exactly, at most, fewer than, at least, and more than carefully: each can refer to a different set of outcomes.
Calculate an at-least probability without summing every case. If B3 contains the minimum count and B1 and B2 still contain the trial count and success probability, enter =1-BINOM.DIST(B3-1,B1,B2,TRUE). For a target of four, this calculates P(X ≥ 4), because it removes the chance of getting three or fewer from 1. With the example inputs, the result is about 0.350389282, or 35.0389%. This complement method is often simpler and less error-prone than adding individual probabilities.
Use the function that matches a different discrete distribution. For a Poisson model, put the average event count (the mean) in B1 and the count you want in B2. To find the probability of exactly that count, enter =POISSON.DIST(B2,B1,FALSE). For a mean of 2.5 and a target count of 3, the result is about 0.213763, or 21.3763%. Set the last argument to TRUE for the probability of that count or fewer. Do not choose a distribution only because its function is available; the model must match how the data arise.
Look up a probability from a supplied discrete table. If possible values of X are in A2:A7, their probabilities are in B2:B7, and the value to find is in D2, enter =XLOOKUP(D2,A2:A7,B2:B7,"Not found",0) in E2. This returns the probability beside an exact matching value, or Not found if the value is absent. XLOOKUP is available in Microsoft 365 and Excel 2021 or later. In older Excel versions, with the same layout, use =IFERROR(INDEX($B$2:$B$7,MATCH(D2,$A$2:$A$7,0)),"Not found") instead. Check that the table’s probabilities sum to 1, allowing for rounding.

For a continuous variable, the notation needs a different interpretation. A continuous distribution assigns probability to intervals; the probability of one exact value such as X = 100 is zero. If you mean the chance that a normally distributed value falls between 90 and 110, put the mean in B1, standard deviation in B2, lower bound in B4, and upper bound in B5. Enter =NORM.DIST(B5,B1,B2,TRUE)-NORM.DIST(B4,B1,B2,TRUE). With a mean of 100, standard deviation of 15, and bounds of 90 and 110, this returns approximately 0.4950, or 49.50%. The formula subtracts the cumulative probability at the lower bound from the cumulative probability at the upper bound; it is an interval probability, not P(X = 100).

Common Mistakes

Using TRUE when you want exactly x. TRUE returns a cumulative probability up to and including x. Use FALSE for exactly x in BINOM.DIST or POISSON.DIST.
Mixing up the argument order. In BINOM.DIST, the target count comes first, followed by trial count and success probability. Reversing inputs can produce an error or a plausible-looking but incorrect result.
Entering 30 instead of 30%. A probability argument should be between 0 and 1. Enter 0.3 or 30% for a 30% chance.
Using a binomial model when its assumptions do not hold. The number of trials must be fixed, each trial must have two relevant outcomes, the success chance must stay constant, and trials must be independent. If those assumptions fail, the result may not describe your situation.
Calling a density an exact probability. For continuous distributions, a density value from a function is not the probability of one exact measurement. Calculate the probability across a meaningful range instead.
Misreading a decimal result. A result of 0.20 means 20%, not 0.20%. Format the cell as a percentage or multiply by 100 for a numeric percentage value.

Tips

Keep inputs, formula, and interpretation together. Label cells and record what counts as a success so someone reviewing the sheet can verify the model.
Use percentage formatting rather than changing the underlying formula. Select the result cell and choose Home > Number > Percent Style. Adjust decimal places with the increase or decrease decimal buttons if needed.
For a one-time check, compare an exact probability with the cumulative result for the same x. The cumulative probability should be at least as large as the exact probability, since it includes that outcome plus lower ones.
Use Ctrl+1 on Windows to open Format Cells and set a desired number of decimal places. On Mac, Command+1 opens Format Cells. Shortcuts can vary with keyboard layout and Excel settings.
Store the target count in a cell instead of typing it repeatedly into formulas. Changing that input then updates the result and makes the calculation easier to audit.

Troubleshooting

Excel displays #NUM!. Check that the number of trials is a nonnegative whole number, the target count is between zero and the number of trials, and the success probability is between 0 and 1. A target count greater than the trial count is not possible in a binomial model.
Excel displays #VALUE! or the result seems unrelated to the inputs. Confirm that the cells contain numbers rather than text. A number pasted with a leading apostrophe or extra spaces may be treated as text. Re-enter the value, or check the decimal separator expected by your regional settings.
You see a formula instead of a result. Make sure the cell is not formatted as Text, remove any leading apostrophe, and enter the formula again. Also check that Show Formulas is not enabled; press Ctrl+` on Windows to toggle it. The Mac shortcut can differ by keyboard layout, so use Formulas > Show Formulas if the shortcut is unavailable.
The answer is off by a factor of 100. A probability normally appears as a decimal. If the cell shows 0.2, that is 20%. If it shows 20 while percentage formatting is applied, inspect the formula and input values rather than multiplying or dividing at random.
XLOOKUP returns Not found. Check that the target in D2 exactly matches an entry in A2:A7. Numbers stored as text will not always match numeric values; make the data types consistent and look for stray spaces in text keys.
The requested probability is “at least” or “between.” Translate the wording into inclusive or exclusive bounds before calculating. For a binomial “at least x,” use the complement formula in the steps. For a continuous “between a and b,” subtract the lower cumulative result from the upper one.

Frequently Asked Questions

What does P(X = x) mean?
It means the probability that the random variable X takes the particular value x. The appropriate Excel calculation depends on whether X is binomial, Poisson, another discrete variable, or continuous.

What is the difference between FALSE and TRUE in BINOM.DIST?
FALSE returns the probability of exactly the specified number of successes. TRUE returns the cumulative probability of that number or fewer.

Can I calculate P(X > x) with Excel?
Yes. For a binomial count with x in B3, trials in B1, and success probability in B2, use =1-BINOM.DIST(B3,B1,B2,TRUE). This subtracts P(X ≤ x) from 1, leaving P(X > x).

Why does the probability show as a decimal?
Excel stores probabilities as decimals between 0 and 1. Apply percentage formatting to display 0.2 as 20%, or leave it as a decimal if that is more useful for later calculations.

Can I use BINOM.DIST for a normal distribution?
No. BINOM.DIST is for binomial counts. For a normal variable, use NORM.DIST for cumulative probabilities and subtract cumulative values to find an interval probability. A continuous variable has zero probability at one exact point.

What if my probability table has repeated X values?
An exact-match lookup returns only one matching row. If repeated values represent separate probability contributions, combine their probabilities first, or use a sum-by-condition approach. Confirm that the combined probabilities still make sense for the distribution.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.