Forum Discussion
Determining random numbers that add up to a predetermined sum
Hello Everyone, My goal is to create a random set of numbers that add up to a particular total. In the image below, you'll see a column of 10 numbers and its total in A12. What function would I nee...
To avoid zero numbers (I guess you mean integers under numbers) and avoid rounding errors we could split the range on 3 parts and calculate as here
- Hello Sir,
Thank you for giving the solution. Thank you so much sir😊😊
