|  

» Generate a random value between two limits in Microsoft Excel

Enter the following values in cell A1 and A2: 65, 84 (these values will act as the lower and upper bound limits)

Enter the following formula in cell B1: =RANDBETWEEN(A1,A2)

A random number between 65 and 84 will be generated



Rate This Tip
12 34 5
Rating: 2.74     Views: 39407
random number generator
Art Swallow  Posted on: 31-12-1969
this formula does not work in my Excel 95.
actually, what I'm looking for is a "formula" that will generate, for example, 24 non repeating numbers between 1 and 24.
randbetween
John  Posted on: 31-12-1969
1- install Analysys ToolPak
2-in cell A1 enter a bottom number, in cell a2 enter the top number
Name
Comment Title
Comments