answersLogoWhite

0

The function called RANDBETWEEN() gives random numbers between two specified values. So to get a random number between 1 and 100 you would put:

=RANDBETWEEN(1,100)

It requires the Analysis Toolpack Add-in to be installed in order to work.

User Avatar

Wiki User

12y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
ViviVivi
Your ride-or-die bestie who's seen you through every high and low.
Chat with Vivi
JordanJordan
Looking for a career mentor? I've seen my fair share of shake-ups.
Chat with Jordan

Add your answer:

Earn +20 pts
Q: Excel random numbers
Write your answer...
Submit
Still have questions?
magnify glass
imp