Random number between 2 limits in Excel

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 can I find the number of working days between 2 dates given a holidays list?

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

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

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

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

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

7) How to find the column number from the cell address in VBA

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

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

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


Here the previous and next chapter