RAND Function in Excel: Syntax, Examples and Free Practice
RAND is an Excel Math & Trig function. Returns a random decimal number between 0 and 1.
RAND syntax
=RAND()
When to use RAND
RAND is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice RAND online, free
Open the live Excel-style spreadsheet and try RAND yourself. No Excel install or sign-up needed to start.
Practice RAND now →More Math & Trig functions
Frequently asked questions
What does the RAND function do in Excel?
Returns a random decimal number between 0 and 1.
What is the syntax of RAND in Excel?
The syntax is =RAND().
Where can I practice RAND online for free?
Open the free live spreadsheet on Cellgrids and try RAND yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts