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

JudyJudy
Simplicity is my specialty.
Chat with Judy
MaxineMaxine
I respect you enough to keep it real.
Chat with Maxine
FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran

Add your answer:

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