creating a variable between two numbers

J

J.E. McGimpsey

How do I create a numerical variable between for example 1000 and 2500?
Thanks
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting a Profile 1
VBA word change keys 0
Justification function versus wide spaces 0
Inconsistent formatting of section numbers 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
I need to place a rule between columns 0
Creating Different Headers in Word 0
Finding the proper style field and the numbered paragraph value within the style 0

Top