Formula in Excel scenarios

%3CLINGO-SUB%20id%3D%22lingo-sub-2049638%22%20slang%3D%22fr-FR%22%3EFormula%20in%20Excel%20scenarios%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2049638%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3Efirst%20of%20all%20accept%20my%20apologies%20for%20my%20poor%20English.%3C%2FP%3E%3CP%3Ei%20would%20like%20to%20know%20if%20it%20is%20possible%20to%20use%20a%20formula%2C%20let's%20say%20Rand%20rather%20than%20a%20fix%20number%20when%20building%20a%20scenario%20(scenario%20analysis%20excel%20tool)%3F%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20practical%20terms%20I%20have%20a%20model%20that%20results%20depends%20of%20multiple%20parameters%20(IPI%2C%20interest%20rate%2C%20building%20cost...)%3B%20the%20final%20result%20depends%20on%20the%20combination%20of%20these%20parameters%20values.%3C%2FP%3E%3CP%3EI%20have%20already%20built%20scenarios%20with%20several%20fixed%20values%20for%20each%20parameter%20but%20I%20would%20like%20to%20know%20if%20I%20can%20get%20a%20wider%20variety%20of%20results%20that%20would%20depend%20on%20a%20random%20(with%20boundaries)%20value%20for%20each%20parameter%20to%20see%20the%20impact%20on%20my%20result.%3C%2FP%3E%3CP%3EI%20hope%20this%20is%20clear%20enough%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3EStone%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2049638%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

0 Replies