Random number generator

D

deelee

I recently got a new installation of excel but it is in Spanish and a
struggling a bit with the help instructions.

I want to make a random number generator a bit like bingo with th
numbers 1 to 12.
Gracias
 
D

daddylonglegs

Theorectically RAND() can generate a zero, in which case

=ROUNDUP(RAND()*12,0)

will generate zero

better to use

=INT(RAND()*12)+1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Generator in Excel? 4
random letter generation 5
How to save random numbers? 3
Random Number generator 2
random number generator 7
Need help removing extra TOC text from number lists used as TOC levels 0
setting up random number generator for lotto numbers 1
Random Number Generation 1

Top