Five Random Numbers To Get A Given Number
Вставка
- Опубліковано 25 сер 2024
- The objective of this video is to generate 5 random numbers that sum up to a certain value. I will be using iterative calculations which is a feature not used much in Excel. Hope this is useful.
Hello sir,your session is very informative and helpful but few values remain unchanged.what is the reason for that.
Thank you very much for your informative tutorial.
انت رائع يا دكتور
ملك الاكسل
What if a column or all the columns have different range but the summation of row is fixed.
In this video all the values are between 1 and 12. Now for example if column A values lie between 11 and 21 (and values for rest of the columns B,C,D&E is between 1 and 12)
How we will maintain the row 1 summation as 31.
what is important is that there is a way it might happen. Eventually it will reach that value .
thank you for the help
How can I contact you directly??
I have a query to generate 40 random numbers to get a predetermined sum that i mention on column
Can you guide?
sure... sorry just saw it
Hello sir good day I would like to learn how to divide from 1 to 59 to get a particular 4 number
I didn't get it.
Pls. Give me yung sample