CODEWITHSUNDEEP
excel
JChen
JChen

Reputation: 1

Produce random numbers with average in excel

How to produce random numbers with average in excel with giving total amount. For example I need to have 12 rows result in total amount been giving with random number.

Which is 30000 total amount been giving and I would like to divide into 12 rows with random number. How could I do this?

Upvotes: 0

Views: 234

Answers (1)

Shalvin Abraham
Shalvin Abraham

Reputation: 458

Formula for Random Values to get a constant sum

Above trick can achieve the goal..

Upvotes: 1

Related Questions