Excel provides built-in functions to generate random numbers for simulations, sampling, or testing. Use RAND for decimals and RANDBETWEEN for integers.
Fallo con l'IASelect a cell
Click on the cell where you want the random number to appear.
Enter the RAND function
Type '=RAND()' to generate a random decimal between 0 and 1, then press Enter.
Enter the RANDBETWEEN function
Type '=RANDBETWEEN(bottom, top)' replacing bottom and top with your desired range, then press Enter.
=RANDBETWEEN(1, 100)RAND and RANDBETWEEN are volatile functions that recalculate whenever the worksheet is updated.