RiskVaryTable
|
Description |
RiskVaryTable(base, table) specifies an input variable for a What-If analysis along with a table of values to substitute for the input. The table of values can be directly entered in the function itself or a reference to the location of the table can be entered. Any number of values can be included in a referenced table. |
|
Examples |
RiskVaryTable(100,{70,80,90,110,120,130}) specifies a What-If input with a base value of 100. Six different values — 70, 80, 90, 110, 120, and 130 — are returned by the RiskVaryTable function during a What-If analysis and results are calculated at each of the six values. RiskVaryTable(100,A1:A100) specifies a What-If input with a base value of 100. Each of the 100 values in the range A1:A100 is returned by the RiskVaryTable function during a What-If analysis and results are calculated at each of the returned values. |
|
Guidelines |
Table values directly entered into the RiskVaryTable function must be entered as arrays with {} notation. The number of steps settings will not be considered if the table has fewer or more values. |