Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |