Recent

6/recent/ticker-posts

Header Ads Widget

Random Number


There is two major function in excel to find the random number. The RAND() and RANDBETWEEN() function return the random number in excel

RAND ()
The rand function returns the random value between 0 and 1. This function always returns the decimal value
to Apply RAND() function
1. select A1
Random Number in excel

2 Type =RAND() and press enter, Remember that RAND() function not required any argument.
Random Number in excel


Remember that the cell where we apply RAND() function the value of cell will changes frequently so if you want this number fixed copy and paste as values

RANDBETWEEN()
RANDBETWEEN() function accept two arguments which are Bottom and top that means random number between lower and High value, RANDBETWEEN() function accept bottom and top and return the random value between these two number
=RANDBETWEEN(Bottom, top)

To apply RANDBETWEEN
1. select E1
Random Number in excel

2. type =RANDBETWEEN(10,100)

Post a Comment

0 Comments