Jan 11 2021 09:15 AM
Hi,
first of all accept my apologies for my poor English.
i would like to know if it is possible to use a formula , let say Rand rather than a fix number when building a scenario (scenario analysis excel tool) ?
In practical terms I have a model which results depends of multiple parameters (IPI, interest rate, building cost...); the final result depends on the combination of these parameters values.
I have already built scenarios with several fixed values for each parameter but I would like to know if I can get a wider variety of results that would depend on a random (with boundaries) value for each parameter to see the impact on my result.
i hope this is clear enough :)
thanks
pierre