ExcelBanter - Randomize three variables subject to sum always equal to 1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Randomize three variables subject to sum always equal to 1 (https://www.excelbanter.com/excel-programming/308477-re-randomize-three-variables-subject-sum-always-equal-1-a.html)

mangesh_yadav[_49_]

Randomize three variables subject to sum always equal to 1

I don't think there should be any problem on this one/ Just find
random numbers between 0 and 1. The third number can be found by th
following equation:

w(2) = 1 - w(0) - w(1)

- Manges

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 11:45 PM.