If it is homework then perhaps it is also English homework <g

1. Generate a random number from 0 to 10 exclusively

I read exclusively as meaning not 0 or 10

Similarly:

2. Generate a random number within 1 to 100

may also mean not 1 or 100

and:

3. Generate a random number between 100 and 1000.

may mean not the limits

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"N Harkawat" wrote in message
...

1) int(rand()*11)

2) =CEILING(RAND()*101,3)

3) =MAX(100,(INT(RAND()*1001)))

4)=DATE(2005,INT(RAND()*13),INT(RAND()*31))
"Christopher" wrote:

Hi,
I would like the formulas to generate the following results on excel
2003:

1. Generate a random number from 0 to 10 exclusively

2. Generate a random number within 1 to 100 which is multiple of 3.

3. Generate a random number between 100 and 1000.

4. Produce a random date in year 2005.



I would also want the answer from the question below:

What is the output (possible range) of the following formula?

=INT(RAND()*10) + INT(RAND()*20)+5

Thx in advance for all your help!

Best Regards,
Christopher