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