rand function

Hi guys, I am tryin really hard to find a solution to this but no luck so far. I need two sets of random values. 1. Between 1 & 4. With one decimal 2. Between -17 & -20. With one decimal Can you please help me achieve this? Thank you heaps.

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

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%...

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

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

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

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

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?

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

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

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

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