Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Use the RANDBETWEEN Function in Excel?

Date:2022-2-23 Author:Sandra

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?

How to Use the RANDBETWEEN Function in Excel?

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

How to Use the RANDBETWEEN Function in Excel?

Why does there show #NAME? in cell B7?

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

How to Use the RANDBETWEEN Function in Excel?

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.

How to Use the RANDBETWEEN Function in Excel?
How to Use the RANDBETWEEN Function in Excel?

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

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *