RAND function with categories

[benny]

Hi..it seems so simple but i couldn't make it.
What RAND function I should applied if I want to generate some randoms value
between 100 and 1000.

Many thanks and much appreciate for help.

 

[Dr. Stephan Kassanke]

Hi..it seems so simple but i couldn't make it.
What RAND function I should applied if I want to generate some randoms
value
between 100 and 1000.

Many thanks and much appreciate for help.

Hi Benny,

Rand() yields numbers between 0 and 1. You can transform this interval with
the following formula (abs cuts off the fractional part):

Abs(Rand() *900 +100)

or generally

Abs(Rand() * (UpperBound - LowerBound) + LowerBound)

cheers,
Stephan

 

[Bruno Campanini]

Hi Benny,

Rand() yields numbers between 0 and 1. You can transform this interval
with the following formula (abs cuts off the fractional part):

Abs(Rand() *900 +100)

or generally

Abs(Rand() * (UpperBound - LowerBound) + LowerBound)

cheers,
Stephan

Sorry Stephan, you said correct but you wrote wrong:

Int(Rand() * (UpperBound - LowerBound) + LowerBound)

Ciao
Bruno

 

[Dr. Stephan Kassanke]

Sorry Stephan, you said correct but you wrote wrong:

Int(Rand() * (UpperBound - LowerBound) + LowerBound)

Ciao
Bruno

so true, Int(...) is the way to go. Thanks for the correction. Just tried it
now and VBA does not like/know Rand(). It's called Rnd().

Stephan

 

[Dave Peterson]

I think you meant =Int(), not =abs().

=int(Rand()*900+100)

 

[Dr. Stephan Kassanke]

I think you meant =Int(), not =abs().

=int(Rand()*900+100)

mea culpa. Yor are absolutely correct.

cheers,
Stephan

 

[RagDyeR]

The formula to return random numbers between 2 set points is:

=RAND()*(b-a)+a

Where a = minimum limit
And b = maximum limit

So, for your question, use this formula:
=RAND()*900+100

To eliminate the decimals, you can Round() the formula:
=ROUND(RAND()*900+100,0)

The formula changes slightly if you truncate the decimal using Int():
=INT(RAND()*901+100)

This change insures that the maximum limit has the *possibility* of being
returned.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi..it seems so simple but i couldn't make it.
What RAND function I should applied if I want to generate some randoms value
between 100 and 1000.

Many thanks and much appreciate for help.