mercredi 16 octobre 2019

Create list of random numbers between x and y using formula in Google Sheets

I'm trying to create a list of 50 random numbers let's say between 100 and 500 with one formula in Gsheets. Is there any formula like 'apply this to x cells'?

What I tried so far is (and doesn't work). I hoped randarray function will 'force' randbetween function to create 2D array (randarray creates a list of numbers between 0 and 1).

={
RANDARRAY(50,1), ARRAY_CONSTRAIN(RANDBETWEEN(100,500),50,1)
}

Error Function ARRAY_ROW parameter 2 has mismatched row size. Expected: 50. Actual: 1.

So this error indicates that array_constrain didn't help either.




Aucun commentaire:

Enregistrer un commentaire