# EXPONDIST

EXPONDIST(x, lambda, cumulative)

Returns the probability distribution function OR the cumulative probability function for an exponential distribution.

 x The value of the function. lambda The parameter value. cumulative A logical value indicating the type of function to use:False (or 0) = [[probability distribution function]] (equal to)True (<> 0) = [[cumulative probability function]] (equal to or less than)

 REMARKS
 * EXPON.DIST was added in Excel 2010 to replace this function.* The exponential distribution is a [[continuous distribution]]* If "x" < 0, then #NUM! is returned.* If "x" is not numeric, then #VALUE! is returned.* If "lambda" = 0, then #NUM! is returned.* If "lambda" is not numeric, then #VALUE! is returned.* If "cumulative" = False, then the height of the curve at "x" is returned.* If "cumulative" = True, then the area under the curve to the left of "x" is returned.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =EXPONDIST(0.2, 10, TRUE) = 0.865 2 =EXPONDIST(1, 4, 1) = 0.982 3 =EXPONDIST(0.2, 10, FALSE) = 1.353 4 =EXPONDIST(0.2, 0, FALSE) = #NUM! 5 =EXPONDIST(5, "some text", FALSE) = #VALUE!