deepcalc
DocsRANDARRAY

RANDARRAY

View as markdown/docs/functions/randarray.md Ask Claude about this pageOpens Claude with this page's address

Returns an array of random numbers.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Array
  • Volatile: recomputes on every evaluation

Examples

=RANDARRAY(1,1,10,5)
Result #VALUE!
=RANDARRAY(1,1,2,)
Result #VALUE!
=RANDARRAY(1048577, 1)
Result #VALUE!
=RANDARRAY(1,16385)
Result #VALUE!
=RANDARRAY(1000,1001)
Result #ERROR!
=RANDARRAY(0)
Result #CALC!

Syntax

RANDARRAY([rows], [columns], [min], [max], [whole_number])
rows
number optional
columns
number optional
min
number optional
max
number optional
whole_number
boolean optional

Errors

#VALUE!
=RANDARRAY(1,-1)
#ERROR!
=RANDARRAY(1000,1001)
#CALC!
=RANDARRAY(1,0)
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.