RAND

Back to all functions

In order to generate random numbers, we use the RAND function, which produces a random number between 0 and 1.
Unlike many other functions, it does not contain any arguments. Instead, we simply write Equals, RAND, and two empty parentheses.
This gives us a random sequence of digits. If we copy the function downwards, each of the new cells will contain a different set of digits.
Also note that the first cell also changed. This is because the function is remade every time any cell on the sheet is updated.
If we want to copy just the values that have been generated, we’ll have to copy, and paste values.
Since the random number is between 0 and 1, we can decide how large of a value the maximum number will be, by simply multiplying the RAND function by whatever number we want…
In this lesson we have gone through the RAND function, which lets us generate random numbers.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Vi hjälper dig att välja rätt onlinekurser för företaget

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.

Contact