How do you generate a random number between two numbers in Excel? The best answer would exactly be the RANDBETWEEN function. So, how to use the RANDBETWEEN function in Excel? Let’s get started.

Syntax

=RANDBETWEEN (bottom, top)

Bottom- The smallest value (starting value) of the range.

Top- The largest value (ending value) of the range.

Why does there show #NUM! in cell B7?

The error of showing #NUM! means the bottom number provided is greater than the top number like below.

Why does there show #NAME? in cell B7?

The error of showing #NAME? means the supplied parameters are not numeric types.

If you want to get a set of random numbers in multiple cells, you need to select the cells then, enter RANDBETWEEN (bottom, top) in the formula bar. Remember to press Ctrl and Enter keys.

That’s all about the RANDBETWEEN function. Hope this can be helpful to you guys. See you next time.