The Excel functions for generating random numbers are RAND, RANDBETWEEN, and RANDARRAY. Generating random numbers in Excel is as easy as typing in the appropriate function, adding parameters (if ...

=RANDARRAY (20,1,50,100,TRUE) into cell A2 returns a random list of whole numbers between 50 and 100 in cells A2 to A21. To do the same in a formatted table, in cell A2, type: =RANDBETWEEN (50,100) ...