Create random number from 3-10

**oldchippy** · 05-05-2009, 10:49 AM

Sorry mate, I was sure I read that as

=RANDBETWEEN(3,1)

Need to change eyes

**maacmaac** · 05-05-2009, 11:06 AM

Didn't expect so many solutions but much appreciated. Good to know for future reference.

I ended up using =INT(8*RAND()) + 3 and/or =round((rand() *7 + 3),2) . Could not use the Randbetween function as my company is still using Office 2000.

Thanks for comments.

**shg** · 05-05-2009, 02:14 PM

If you use ROUND, the end-point numbers will occur with half the likelihood of the interior numbers.

To see a quick example, copy =ROUND(3 * RAND(), 0) down 600 rows. On average, you'll see 100 0's, 200 1's, 200 2's, and 100 3's.