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.
Chat with our AI personalities