random number between 2 limits in Excel

Q58. In Excel, how can I generate random numbers between 2 limits?

For example, I am setting up a quiz game for kids. I have 30 questions. I would like to choose one random number between 1 and 30 to start the quiz.

To do it in Excel, here is the answer:

a) Enter the formula =RANDBETWEEN(1,30) in an empty cell.

Note: Every time the workbook is recalculated, the cell containing the RANDBETWEEN formula is also recalculated. Hence the value in this cell is not STATIC.

excel random number between 2 limits


You can find similar Excel Questions and Answer hereunder

1) How do I change the rating numbers to rating labels?

2) How do I get the rank of a number in a list of numbers?

3) Millions thousands custom number formatting in Excel

4) In my organization different users have different versions of Excel - how do I check compatibility issues with my WorkBook across versions?

5) Concatenate number with text but keeping in number format in Excel

6) In a Table , how can I add a Total Row that displays the maximum value in a column of numbers?

7) How can I get row count of filtered data?

8) How can I find number of months that has elapsed given 2 dates?

9) How can I find the number of working days between 2 dates given a holidays list?

10) How can I convert Column numbers into Column names for use in range definition?

11) How can I find the number of working days between 2 dates using VBA?

12) How can I find time interval between 2 times?

13) Can I determine the number of times a character appears in a cell using formula?

14) Can I apply formatting to a number concatenated with a Text?

15) How can I get the day number of the year for a date - for example 5 for Jan 5, 33 for Feb 2?