How do I create a numerical variable between for example 1000 and 2500?
Thanks
I'm not entirely sure what you're after. If you want a random number
between 1000 and 2500 you can use
=RANDBETWEEN(1000,2500)
RANDBETWEEN is part of the Analysis Toolpak Add-in
(Tools/Add-ins...). This accomplishes the same thing with native
functions:
=INT(RAND()*1501)+1000
If that's not what you're after, please post back with more details.
