How to use EXPON.DIST Function in Excel

The EXPON.DIST function returns the exponential distribution. Use EXPON.DIST to model the time between events.

Syntax:= EXPON.DIST(x,lambda,cumulative)

The EXPON.DIST function syntax has the following arguments:

  • X     Required. The value of the function.
  • Lambda     Required. The parameter value.
  • Cumulative     Required. A logical value that indicates which form of the exponential function to provide. If cumulative is TRUE, EXPON.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Example: Let’s look at some Excel EXPON.DIST function examples and explore how to use the EXPON.DIST function as a worksheet function in Microsoft Excel:


Result: 0.389400392

Based on the Excel spreadsheet above, the following EXPON.DIST examples would return:

Result: 0.60653066

Result: 0.735758882

Result: 0.221199217

Result: 0.39346934

Result: 0.632120559


  • If x or lambda is nonnumeric, EXPON.DIST returns the #VALUE! error value.
  • If x < 0, EXPON.DIST returns the #NUM! error value.
  • If lambda ≤ 0, EXPON.DIST returns the #NUM! error value.
  • The equation for the probability density function is:

  • The equation for the cumulative distribution function is:

Add a Comment

Your email address will not be published. Required fields are marked *