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
|