How to generate random number in Excel

In order to generate a random number in excel, you can use the RAND() function.

Please consider that the RAND() Excel function returns a value between 0 and 1.

You can multiply this value with your required range if you need bigger numbers, or integers. Also, please consider that any recalculation made on your Excel sheet, will refresh the generated random numbers

Random numbers in excel between two limits (min/max)

If you need random numbers between two limits, you can use function RANDBETWEEN(min, max) function in Excel

Microsoft Documentation about RAND and RANDBETWEEN excel functions

You can read more about RAND and RANDBETWEEN excel functions on Microsoft Documentation here: Microsoft docs