Applies to: @RISK for Excel 4.x and Up

How to Get the Number of Iterations into a Worksheet

Overview
This article explains how to display the number of simulation iterations directly in an Excel worksheet when using @RISK.

Solution

To return the total number of iterations used in the current simulation, enter the following formula into a worksheet cell:

=RiskSimulationInfo(4)

Details

• The function updates automatically after a simulation is run.

• This value reflects the iteration count defined in the simulation settings.

• Useful for reporting, dashboards, and documentation of simulation results.

Notes

• The function returns 0 if no simulation has been run.

• Available only while @RISK is loaded and active.