|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
#1 |
|
Member (9 bit)
|
excel problem
i have some questions regarding excel. i want to randomly select some number from a list and sum them. how would i be able to set a formula to randomly select some number.
|
|
|
|
|
|
#2 |
|
Member (10 bit)
Join Date: May 2000
Location: New Zealand
Posts: 546
|
You can create random numbers using the RAND function.
Why do you want to sum random numbers though? If you create a random number from, say, 0 to 1, and them sum, say, 5 of them, isn't that the same as creating a random number between 0 and 5? David. Last edited by David_Jones; 10-13-2003 at 07:47 PM. |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|