Home → Techniques and Tips → @RISK: General Questions → Placing Number of Iterations in the Worksheet
Applies to: @RISK for Excel 4.x–7.x
@RISK puts the number of iterations into reports and windows, but how can I get it into my worksheet? I need to use it in calculations.
With @RISK 6.x/7.x, use the formula =RiskSimulationInfo(4).
With @RISK 5.7 and below, place =RiskCurrentIter( ) in any convenient cell, say for example AB345, and then the formula =RiskMax(AB345) in any other cell will give you the number of iterations upon completion of the simulation.
Additional keywords: SimulationInfo, CurrentIter
Last edited: 2015-06-08