I want a random number from 1 and 10, and I want it to be a whole number.
In column A, generate a random number from 0 to 9 with decimals 10*rand()
, but wrap that in the ROUNDUP
function to round it up!
Remember that the ROUNDUP(N,0)
function takes two inputs.
Make sure you get only whole number outputs from 1 to 10.