RiskIsDate
Description
|
RiskIsDate(TRUE or FALSE) specifies whether the input or output for which it is entered should be treated as a distribution of dates for displaying graphs of simulation results and calculating statistics. If RiskIsDate is not entered, @RISK will use the formatting 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 for an input distribution, argument values will be displayed as dates in the Define Distribution window.
|
Examples
|
RiskOutput(,,,RiskIsDate(TRUE)) specifies that the output distribution will be displayed using dates, regardless of the cell formatting 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.
|
Guidelines |
RiskIsDate(FALSE) causes @RISK to display graphs and reports for the input or output in values, not dates, even if the cell where the function is located in Excel has date formatting. |