# EXPONDIST

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the exponential distribution or the probability density.

## Syntax

EXPONDIST(*value*,*lambda*,*cumulative*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *value* | Value of the function; must be positive or zero |
| *lambda* | Parameter value; must be greater than zero |
| *cumulative* | Logical value indicating whether to return the cumulative distribution; set to TRUE to return the cumulative distribution; set to FALSE to return the probability density |

## Remarks

Use this function to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use this function to determine the probability that the process takes at most one minute.
The cumulative distribution is calculated as follows:
![Equation EXPONDIST cumulative distribution](https://cdn.mescius.io/document-site-files/images/0ed25d3e-6b2a-4cf0-8f1b-7ed5ab18cf12/artwork/func-expondist-false.png)
where x is the *value* argument, lambda is the *lambda* argument.
The probability density is calculated as follows:
![Equation EXPONDIST (probability density)](https://cdn.mescius.io/document-site-files/images/0ed25d3e-6b2a-4cf0-8f1b-7ed5ab18cf12/artwork/func-expondist-true.png)
where x is the *value* argument, lambda is the *lambda* argument.

## Data Types

Accepts numeric data, except the third argument, which accepts logical data. Returns numeric data.

## Examples

`EXPONDIST(C12,10,TRUE)`
`EXPONDIST(R12C3,8,FALSE)`
`EXPONDIST(0.2,10,TRUE)` gives the result 0.8646647168

## Version Available

This function is available in product version 1.0 or later.

## See Also

[BINOMDIST](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionBINOMDIST) \| [Statistical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsstats)