# rand function

1. ### Excel Formulas to generate random values adding upto 100

Hi Experts, Need your help in this. My boss wants me to create values for a group of materials bifurcated on basis of pack x Channel, now the values for a pack/channel combination should sum up to 100. <tbody> Unit Brand Channel Pack Value% EAST Product 1 Insti Medium EAST Product 1...
2. ### RAND() Function Within Nested IF Statement

Hi All, I hope everybody is doing well today. My name is Gary and I am new here. Although I've used the =RAND() function inside nested IF statements before, a simple question just occurred to me. Suppose I want to sample a distribution that returns "1" with 20% probability, "2" with 50%...
3. ### RANDOM select strings, and No REPEAT selection

Dear Excel Experts, I found formulas that allow users to select names randomly:- =INDEX(\$A\$2:\$A\$11,RANDBETWEEN(1,COUNTA(\$A\$2:\$A\$11)),1) But how do we omit the one that has appeared/selected to avoid repetitive value? The reason why I need this is to ensure staff select unique tasks, no one...
4. ### How to randomly generate list of names that can vary in length

So i would like to create a league table that has the ability to generate a random (or certainly something that appears random possibly using RAND or RANDBETWEEN) set of plays/matches of singles, doubles and trebles. So on my darts team there is the POSSIBILITY of 4 to 7 players. (THIS...
5. ### Help using if functions, rand() & inequalities all in one equation

I am trying to form an "if" function. Given set probabilities a certain number of magazines are sold. In this situation a randomly generated number (rand()) is checked against a probability range from (0-1.0) generates a given value for those specific ranges (0-.5 is 50, .5-.15 is 75 ... for...
6. ### Need Help on a Homework Assignment

Working on something for class. Instructions are as follows: Ask the user for a positive integer (num), below 100. If the user enters a negative number or greater than 100, give a warning and ask to re-enter. Generate 20 positive random numbers between (1- num). Display the generated random...
7. ### RAND Function

so I've got this code which uses the RAND function and it keeps on re calculating every time, is there any way I can stop this or use some other similar function?
8. ### Generating Random numbers

Hi all, I need help with generating random numbers that equal a specific total. for example: I want random numbers from A1 to A15 that equal to 6 I would need the same for columns B through J And as an added bonus stump question :) I need each of those rows to equal a specific number all the...
9. ### Question about rand between formulas

Hi there, My co-worker and I are trying to solve a excel riddle and we'd love some help to find an answer (if there's one)! We're trying to use Excel to randomize fourteen individual sums that add up in total a certain amount of money but doesn't go pass said amount. So an example is 1-14...
10. ### RAND() and permanently capturing the results

Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am currently using “=ROUND(<?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags"...