# Knowledge Base

SimulationInterval Bounds

The `SimulationInterval` function returns the portion of a simulation – as a percentage – that falls within some bounds.

If you omit one of the bounds, then the function will return the portion that falls above (or below) the given bound. For example,

``````=SimulationInterval(A1,0,1)
``````

returns the portion of the simulation that falls within 0 and 1, inclusive.

``````=SimulationInterval(A1,0)
``````

returns the portion of the simulation that is greater than or equal to zero (only the first bound is provided); and

``````=SimulationInterval(A1,,0)
``````

returns the portion of the simulation that is less than or equal to zero (note the empty parameter – the comma must still be provided).

The bounds are inclusive, meaning that in the first example, it returns results in which `0 <= A1 <= 1`. This has some implications for creating tables.

For continuous variables, it is very unlikely that you will have an exact value 0 or 1, so this is functionally equivalent to `0 < A1 < 1`. Therefore when creating a table, you can use sets of ascending values. For example, you could create a table:

However for discrete values, you may have exact matches. In that event, you should create a table using only one parameter (minimum or maximum, depending on your application) and subtract.

Search the Knowledge Base