Question

What would be the result of typing the function =INT(RAND()*5) into cell B1?

would it creat 5 random numbers in cells B1 to B5
or
would it make a single random number between 1 and 5 in cell b1

Answer 1

The function =INT(RAND()*5) would create a single random number between 1 and 5 in cell B1.