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...
Thank you for the reply sir😊
But i want take any number with the help of RANDBETWEEN function and end up with a total of 310?
But i want take any number with the help of RANDBETWEEN function and end up with a total of 310?
I only sent you the formulas for the solution.
As far as I can see, you have received a proposal for a solution from Mr tauqeeracma, which I am very pleased for you.
I hope you continue to enjoy Excel
Nikolino
I know I don't know anything (Socrates)
As far as I can see, you have received a proposal for a solution from Mr tauqeeracma, which I am very pleased for you.
I hope you continue to enjoy Excel
Nikolino
I know I don't know anything (Socrates)
- Thank you so much sir😊😊