| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to set random numbers that add to 100%?
I need help from anyone with regards to the formula of generating a set of
random numbers that makes up for 100% |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to set random numbers that add to 100%?
If you need N numbers that add up to 100%, do N-1 of them. Then make that last
number: =1-sum(theother N-1 numbers) ggya wrote: I need help from anyone with regards to the formula of generating a set of random numbers that makes up for 100% -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to set random numbers that add to 100%?
ggya wrote:
I need help from anyone with regards to the formula of generating a set of random numbers that makes up for 100% Generate your set of N random numbers. Get the sum of all of them (SumRandNum). Then process (for each) NewRandNum = OldRandNum * 100. / SumRandNum ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random Numbers excluding Previous Numbers | Excel Worksheet Functions | |||
| getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Linear Mode
