# Get instant live Excel expert help with RAND Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need an excel formula that can solve this: I want to introduce a fun game (that gives the customers an advantage). The Game: 1. A random colour machine displays either GREEN or RED. 2. Customer picks a colour and wins if their colour is displayed 3. A round involves 10 games. Of which GREEN is displayed 6 times on average (to give the customer an advantage) 4. Pay out is the stake x 0.7 (so if you select green and bet \$1, your total return is \$1.70 if green appears. But you lose \$1 if red appears) (the customer still has a small advantage) QUESTION: What is the optimal betting strategy, to ensure that the customer wins \$50 after every round (10 games) if the customer started with \$100.
Solved by I. J. in 16 mins
I work in a research lab and we use an Excel file to enter data. The file is saved on a server that multiple people access from different locations. Usually if someone else has it open, it will only open in read-only. Lately, if a second person tries to open it, a message pops up that says "Alert. We found a problem with some content in 'file name.xlsx.' Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." If you click Yes, another pop says "Alert. The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt." At some point (we haven't been able to determine when, as it doesn't seem to be predictable) an empty folder is created, that has the same name as the Excel file but with a string of varying letters and numbers after it. Multiple empty folders like this are created every day. Some examples of the string of letters and numbers are as follows, notice that the first 12 characters repeat: xlsx.sb-388634f5-whyS2F xlsx.sb-388634f5-h0hqXF xlsx.sb-388634f5-GUudM6 xlsx.sb-388634f5-hBFtWk xlsx.sb-388634f5-rkVL5q xlsx.sb-30dc7262-36Lomy xlsx.sb-30dc7262-1I4KOA xlsx.sb-30dc7262-BzfXuT xlsx.sb-30dc7262-ZqrDyE It seems like in general the first 12 characters of each string is the same if the folders were created on the same day, but definitely not always. Sometimes the string is the same over several days, or there are random other strings in the middle of the group of a different string. Any help is greatly appreciated!!
Solved by X. Q. in 14 mins
I am trying to make a random exam generator using a database of numbers with corresponding book questions. The exams 12 questions long with questions being randomly assigned by their number from the database. I have generated exams using RANDBETWEEN and want to print the questions to the exams by their number ID and their color. For example, I have done EXAM 1 by hand. How do I do this en mass? Thanks.
Solved by B. F. in 14 mins
Hello. I am needing some help. I would like to have a excel sheet that randomly pull 10% of my employees at a location so we can conduct a random audit of the driver logs, fueling, and etc. doe this make sense?
Solved by B. S. in 15 mins
Use the RANDBETWEEN function in Microsoft Excel to select three simple random samples of 10, 50 and 500 days from the population. Using just your samples, calculate the mean, median, standard deviations and mode if applicable for each random sample. [10%]. Compare these outcome figures. How do the mean and SD change with sample size? [10%].
Solved by G. Q. in 15 mins
I have picked out 21 numbers out of 69 possibilities. Now I want to randomly pick combinations of 5 numbers and make a list of 39 possibilities. I am trying to make Excel give me a random list of 5 numbers that I can use for Powerball.
Solved by F. H. in 27 mins
Need to generate a list of random numbers but this have to be fulfilled: Must be either 6 or 8 numbers. Must start with 4 if it’s 6 numbers long or 8 if it’s 8 numbers long Must be an even number Must be unique What do I do?
Solved by D. A. in 15 mins
I have a table that has 5 different project types. I have created a random number or "total projects" using probabilities for 0-9 projects. Now I need to calculate randomly the type of projects the total is consisted of. There are 5 project types each with a frequency probability. So I need a formula to output 0-5 numbers from 0-9 in separate columns that total the random numbers I generated. I hope that makes sense
Solved by T. S. in 12 mins
I need help creating a formula. I have a list of values in a column that have random blanks. I want a formula to organize the list so that the blank cells do not appear. *Note this list goes on for a long distance. Example A1 | B1 1 | 1 | 5 5 | 6 6 | 7 | 7 |
Solved by F. F. in 18 mins
How can I generate a random number, from 1-0. I have old excel from OpenOffice. Thanks
Solved by E. W. in 12 mins