answersLogoWhite

0

It is designed to get numbers from zero to below 1. To get numbers from 1 or more, you multiply its result by the number you need. To get numbers from 1 to 2000, not including 2000, multiply like this:

=RAND() * 2000

User Avatar

Wiki User

8y ago

What else can I help you with?

Related Questions

How do you generate random numbers in Excel?

You can use the RAND function or the RANDBETWEEN function.


Which function is used to randomize number in Excel?

There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.There is a RAND function which can generate random numbers. The RANDBETWEEN function can generate numbers between a lower and upper limit.


What would be the result of trying the function INT(RAND)(5) into cell B1?

what would be the result of typing the function =INT(RAND()*5) into cell B1?


What is rand function?

If you are referring to PHP's rand function then.The rand function is a function that is used to generate a random number between and including two fixed values or two varibles.An example of this is:This will generate a number between 1 and 9 including 1 and 9Another exampe of this is:This is also generate a number between 1 and 9 including 1 and 9.I hope this has helped you.


What is rand function in c plus plus?

The rand() function returns an integer (int) value that represents a pseudo-random number between 0 and RAND_MAX, RAND_MAX being a constant declared in the run-time library. Each time rand() is invoked, a different value is returned.


Can Microsoft Excel randomize orders of items in a list?

Just use =RAND() to generate random numbers in your list. Then you can sort it with the random numbers. Comments on answer: Let's just say the list is in column C and has 12 entries. Your answer says to "just use =RAND() to generate random numbers in your list". OK, so where "in the list" would I put the =RAND() function command? And in which cells would that function display the "random numbers in my list" that you suggest? And then, how would I go about sorting "it" with the random numbers that somewhere have been generated? Sorry for being the devil's advocate, but I just want to get clear info on how to do the task you answered.


What is randomize function in c plus plus?

You can use rand(). Make sure that you use srand()to generate the seed for rand() (if you do not, you get so called pseudo random numbers).


How do you do a randomization in Microsoft Excel?

You can create a random number using the RANDBETWEEN function. This allows you to generate a random whole number between a low and high level. For example, to get a random number between 1 and 100, you would do this: =RANDBETWEEN(1,100) You can also use the RAND function to generate a random number between 0 and 1. You can then multiply that by a number to increase the value. Both RAND and RANDBETWEEN regenerate their values every time anything in the worksheet changes and you can also press the F9 key to get them to regenerate a value.


What does the rand between function do in Excel?

It allows you to generate a random number between a range. So say you want to get a random number between 1 and 100, then you would use the RANDBETWEEN function like this:=RANDBETWEEN(1,100)It is a dynamic function, meaning every time something changes on the spreadsheet, it regenerates new numbers. This will also happen if you press the F9 key. It is a good function to get a set of numbers quickly and to test functions with, removing the need for you to create a load of random numbers yourself.


What is the branch name of Nedbank Business North Rand branch code 146905?

The branch name of Nedbank Business North Rand with the branch code 146905 is "North Rand." This branch is located in the Gauteng province of South Africa and offers a range of banking services tailored for business clients.


What works were written by the author Ayn Rand?

Ayn Rand's novels include We the Living, The Fountainhead, and Atlas Shrugged. She also wrote nonfiction books such as For the New Intellectual, The Virtue of Selfishness, and the Romantic Manifesto.


What's one of the random number generators of a pair of dice?

If you just want to roll a die and not learn how to do it, you can type "roll a die" into Google, and it will have a six-sided die for you to roll right on that page. Other sizes of dice rollers will be available in the search results as well. If you want to learn how to do it in Excel though, that is below: If you want to simulate the outcome of throwing a pair of dice (two die), it is easy and I will explain how to do this with Excel. A single die has a discrete uniform distribution, with values from 1 to 6. Some programs have a built in function for computing random values. Excel does not, but it does have a built in continuous random number generator rand() from 0 to 1. Rand() will generate numbers above 0 and below 1, so if I multiply the numbers by 6, I will have numbers above 0 and below 6. I will take this number and use the int function to round down the number to the next lowest whole number, so now I have discrete numbers from 0 to 5. I can add one to these numbers and now I have random numbers 1 to 6. So, in Excel you can use int(rand()*6)+1 to obtain the random numbers. I can put this equation in a second cell, and add them together. You can copy this equation many times and obtain many simulated throws of dice. In Excel, you can hit the F9 key and execute this program, obtaining different random numbers.