Excel FunctionsLesson 103Free preview

RAND

This lesson is part of Excel · All levels

Summary

RAND is an Excel random function that produces a decimal number between 0 (inclusive) and 1 (exclusive). This function is volatile, which means the result changes every time the worksheet is recalculated. For the integers in the range, use RANDBETWEEN.

Key points

RAND produces a decimal number of 0 s/d less than 1
The result changes when the sheet is recalculated (volatile)
The alloy produces a ring from 0 to 99
It's more practical for random integers

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.