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

Structured Data LLC

Structured Data LLC is a software services and consulting firm founded in 2005, with offices in New York and San Francisco.

More Information?

If you'd like more information, please enter your email address below and we will get in touch.

Contact Us