# How to use Excel RAND function

## SUMMARY INFO

All the basic information regarding RAND function is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: RAND Function Category: Math and trigonometry Description: Returns a random number between 0 and 1 Return Value: A number between 1 and 0 Syntax: =RAND () Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: RAND French: ALEA German: ZUFALLSZAHL Spanish: ALEATORIO Dutch: ASELECT Italian: CASUALE Russian: СЛЧИС Danish: SLUMP Swedish: SLUMP Portuguese (Brazil): ALEATÓRIO Polish: LOS Finnish: SATUNNAISLUKU Norwegian: TILFELDIG Portuguese (Portugal): ALEATÓRIO Czech: NÁHČÍSLO Hungarian: VÉL Turkish:  S_SAYI_ÜRET All Other Languages: RAND Related Functions: RANDBETWEEN

## FUNCTION DETAILS

Syntax details with an example regarding the correct usage of function can be seen below.

### =RAND ()

() Rand function doesn’t take any arguments

## VIDEO EXAMPLES

Check the video below to see How to use Excel RAND function with some examples:

Here we provide a list of useful links which we think can be useful while trying to learn the function usage with some examples and tips.

Microsoft Office support page – Excel RAND function:
https://support.office.com/en-us/article/RAND-function-4cbfa695-8869-4788-8d90-021ea9f5be73

## EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: