Microsoft Excel training

Generate random numbers in Excel

In Excel, you can use the Random function to generate random numbers. Together with the Integer function, you can generate a random integer between 0 and given number.

Follow these steps to generate a random integer in Excel

  1. To generate an integer between 0 and 100, enter the following formula into your Excel cell  =INT(RAND()*100)
  2. Save the cell/confirm by hitting the Enter key

Nice, simple and easy.



   
excel, generate, random, integer