There are a few ways to generate random numbers in a range in Excel. One way is to use the RANDBETWEEN function. This function takes two arguments, a bottom and top number, and generates a random number between those two numbers. For example, if you wanted to generate a random number between 1 and 10, you would use the following formula:

=RANDBETWEEN(1,10)

Another way to generate random numbers in a range is to use the RAND function. This function generates a random decimal number between 0 and 1. You can then use the following formula to scale this number up to your desired range:

=RAND()*(top-bottom)+bottom

For example, if you wanted to generate a random number between 1 and 10 using the RAND function, you would use the following formula:

=RAND()*(10-1)+1