Generating a random list of numbers

[JeremySchubert]

Is it possible to get Excel to generate a random list of numbers from the Real Numbers set that includes results with the radical sign, the repeating sign or a fraction?

 

[PeteWright]

You could generate a table with some pseudo-random numbers and format the results (fractions, radical sign, etc.).
Is this what you want?

You could use formulas RAND, RANDARRAY or RANDBETWEEN

RAND will return a random decimal between 0 and 1
RANDARRAY will spill a table with random numbers. You can specify the number of rows and columns, minimum and maximum value and the number type (integer or decimal)
RANDBETWEEN will return a random number within the specified range

 

[JeremySchubert]

You could generate a table with some pseudo-random numbers and format the results (fractions, radical sign, etc.).
Is this what you want?

You could use formulas RAND, RANDARRAY or RANDBETWEEN

RAND will return a random decimal between 0 and 1
RANDARRAY will spill a table with random numbers. You can specify the number of rows and columns, minimum and maximum value and the number type (integer or decimal)
RANDBETWEEN will return a random number within the specified range

Thank you. I will use RANDARRAY to create a table of numbers. Then I will format some of the results as radicals and fractions.
If I want to use RANDARRAY to create both integers and decimals, do I have to create 2 sheets? One using each number type? And then paste the contents of one sheet into the other?

 

[Peter_SSs]

If I want to use RANDARRAY to create both integers and decimals, do I have to create 2 sheets?

No. Here is one way. This formula should, on average produce about half integers and half decimals, though on this particular occasion it has produced just 3 integers out of 10 results. If you want to weight the number of integers v decimals differently, you can change the 0.5 in the formula.

23 10 23.xlsm
	C
1	2
2	5.044089
3	7.64004
4	7.739514
5	4.519902
6	3
7	9
8	6.113683
9	2.745343
10	8.852008
Integers v Decimals

Cell Formulas
Range	Formula
C1:C10	C1	=BYROW(RANDARRAY(10,1,0,10),LAMBDA(r,IF(RAND()<0.5,INT(r),r)))
Dynamic array formulas.