September 17, 2021

# 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:

Syntax:  =EXPON.DIST(B1,B2,FALSE)

Result: 0.389400392

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

Syntax:
=EXPON.DIST(B1,B3,FALSE)
Result: 0.60653066

Syntax: =EXPON.DIST(B1,B4,FALSE)
Result: 0.735758882

Syntax: =EXPON.DIST(B1,B2,TRUE)
Result: 0.221199217

Syntax: =EXPON.DIST(B1,B3,TRUE)
Result: 0.39346934

Syntax: =EXPON.DIST(B1,B4,TRUE)
Result: 0.632120559

Note:

• 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:
READ:  How to use HYPGEOM.DIST Function in Excel

#### Excel

View all posts by Excel →