# 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"...

I have created a list of names on Sheet 1 in column A, but if they have been terminated there is a date in column D. Now I want to schedule random screening of the current names - Need to exlude anyone that has a date listed in column D. (This will be on a second Sheet.) I have figured out how...
12. ### Round() Function & Pivot Tables

I'm using Excel 2007...does anyone know why the the sum of values for one column in my pivot table would differ from the total sum of my linked table? I am using the Round(Rand()*100,0) function to determine the values for each cell in this one column. I notice that these values change each...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back