Forum Discussion
RandArray
I'm trying to make the total of my RandArray set equal a pre-determined total. Is there a way that this can even be done?
Let's say you want an array of 20 elements in a column with sum 500.
=LET(a, RANDARRAY(20), s, SUM(a), a/s*500)
Of course, you can use cell references instead of the fixed values 20 and 500.
What exactly do you want to do?
- HansVogelaar
Create a random number generator with 125 values, a range of 1.1-2.1, where the sum of those numbers equal 245