View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Help on several formulas

Is this homework?

Pete

On Nov 3, 3:45*pm, 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