Go Back   PCMech Forums > Help & Discussion > Software Discussion & Support

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 10-12-2003, 04:01 AM   #1
Member (9 bit)
 
Join Date: Dec 2001
Location: US
Posts: 468
Send a message via AIM to wilbasket23 Send a message via Yahoo to wilbasket23
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.
wilbasket23 is offline   Reply With Quote
Old 10-13-2003, 07:43 PM   #2
Member (10 bit)
 
David_Jones's Avatar
 
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.
David_Jones is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 05:13 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2