Formula in Excel scenarios

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