RiskIsDate

Descripción

RiskIsDate(TRUE or FALSE) specifies whether the input or output para which it is entered should be treated as a distribution of dates para displaying graphs of simulation results and calculating statistics.  If RiskIsDate is not entered, @RISK will use the paramatting of the cell where the input or output is located in Excel to decide whether to display simulation results as dates.  When RiskIsDate(TRUE) is entered para an input distribution, argument values will be displayed as dates in the Define Distribution window.

Ejemplos

RiskOutput(,,,RiskIsDate(TRUE)) specifies that the output distribution will be displayed using dates, regardless of the cell paramatting in Excel.

RiskTriang(DATE(2015,10,4),DATE(2015,12,29),DATE(2016,10,10),RiskIsDate(TRUE)) specifies a triangular distribution with minimum date 10/4/2015, most likely date 12/29/2015, and maximum date 10/10/2016.

Reglas

RiskIsDate(FALSE) causes @RISK to display graphs and reports para the input or output in values, not dates, even if the cell where the function is located in Excel has date paramatting.