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...
How to insert random (integer) numbers between two numbers without repeats in Excel?
Cclick on header for more infos)
This method will apply the RAND function and RANDBETWEEN function to insert random numbers between two numbers into a specified range in Excel. Please view below formulas:
Merci pour votre patience et votre temps.
Nikolino
Je sais que je ne sais rien (Socrate)
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)- Thank you so much sir😊😊