+1 vote
562 views
in Software Testing by (350 points)
i wanna use random function in Excel help me if you know with example.

1 Answer

0 votes
by (590 points)
edited by
These are the example of random function in excel :
 
Make two columns in excel fill some values in column A1, A2, A3 and Just copy this function  =RAND()*(A2-A1)+A1 to cell C3 you would get the random number see given functions below and execute them one by one accordingly. 
=RAND()*(A2-A1)+A1
Result: random number   (between 50 and 149.9999999)

=RAND()*(A3-A1)+A1
Result: random number   (between 50 and 199.9999999)

=RAND()*(200-100)+100
Result: random number   (between 100 and 199.9999999)

=INT(RAND()*(200-100)+100)
Result: random number   (between 100 and 199, integer value)
Thanks!

Not a Member yet?

Ask to Folks Login

My Account

Your feedback is highly appreciated