Excel Function EXPONDIST

EXPONDIST(x, lambda, cumulative)

Returns the exponential distribution.

x	The value of the function.
lambda	The parameter value.
cumulative	The type of function to use True = cumulative probability function False = probability mass function

Remarks

* EXPON.DIST was added in Excel 2010 to replace this function.
* If "x" < 0, then #NUM! is returned.
* If "x" is not numeric, then #VALUE! is returned.
* The exponential distribution is ?? Distribution.
* If "lambda" = 0, then #NUM! is returned.
* If "lambda" is not numeric, then #VALUE! is returned.
* If "cumulative" = True, then the cumulative distribution function is used.
* If "cumulative" = False, then the probability density function is used.
* 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) = =EXPONDIST(0.2,0,FALSE)
5	=EXPONDIST(5,"some text",FALSE) = =EXPONDIST(5,"some text",FALSE)