This is the same formula as before, but using the ROUND function to round to zero decimal places. This multiplies the random number generated by 9 and then adds 1 to it. Applying SORTBY & SEQUENCE Functions to Generate Random Number with No Repeats, 4. } Hence, follow the process to perform the task. Excel Test Cases The RAND function is How to quickly generate random date on earth in Excel? Excel Charts Get instant live expert help on I need help with 4 digit random number generator excel My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 The RAND function in Excel generates a random value between 0 and 1. Press Enter key, now it displays blank as the cell A1 is empty. Run the code again and a different random number will be displayed. You can download the workbook and practice with them. There are several possible solutions available. We also perform data analysis. However, it is considerably less complicated than using the RAND function with operators to achieve the same result. Select Category The above formula creates a sequence of numbers from 1 to 10.