RANDARRAY Function in Excel: Syntax, Examples and Free Practice
RANDARRAY is an Excel Math & Trig function. Returns an array of random numbers.
RANDARRAY syntax
Arguments
rows: How many rows to return or generate (optional)columns: How many columns to return or generate (optional)min: The minimum value allowed (optional)max: The maximum value allowed (optional)whole_number: Whether to return whole numbers only (optional)
When to use RANDARRAY
RANDARRAY is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice RANDARRAY online, free
Open the live Excel-style spreadsheet and try RANDARRAY yourself. No Excel install or sign-up needed to start.
Practice RANDARRAY now →More Math & Trig functions
Frequently asked questions
What does the RANDARRAY function do in Excel?
Returns an array of random numbers.
What is the syntax of RANDARRAY in Excel?
The syntax is =RANDARRAY([rows], [columns], [min], [max], [whole_number]). rows: How many rows to return or generate (optional); columns: How many columns to return or generate (optional); min: The minimum value allowed (optional); max: The maximum value allowed (optional); whole_number: Whether to return whole numbers only (optional).
Where can I practice RANDARRAY online for free?
Open the free live spreadsheet on Cellgrids and try RANDARRAY 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