| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Randomize three variables subject to sum always equal to 1
Hi guys
I need a hand on this one, cuz I have absolutely no clue: I need a code that randomly selects three real numbers between 0 and and assigns these to three variables. I defined the variables as w(0) w(1), w(2). The problem is that the sum has to equal 1! Always! S that: w(0) + w(1) + w(2) = 1 Help is very much appreciated!!! Thanks Emsfel -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF Sum a column subject to variables in two columns | Excel Worksheet Functions | |||
| Variables in the subject line of an e-mail hyperlink | Excel Discussion (Misc queries) | |||
| How do I randomize words within a row? | Excel Discussion (Misc queries) | |||
| Randomize three variables subject to sum always equal to 1 | Excel Programming | |||
| randomize | Excel Programming | |||
![emsfeld[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
