View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Christopher is offline
external usenet poster
 
Posts: 21
Default Help on several formulas

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