Hey there! any question in your mind? Ask It Now!.

Popular Categories





how to use random function in excel?

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

1 Answer

0 votes
answered by smarttester (590 points)
edited by Bhartesh
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!

Related Questions

+3 votes
2 answers 1,981 views
+3 votes
1 answer 578 views
+1 vote
2 answers 6,523 views
+1 vote
1 answer 4,589 views
+1 vote
0 answers 122 views
0 votes
0 answers 248 views
+6 votes
3 answers 7,418 views
+4 votes
1 answer 1,240 views
0 votes
0 answers 250 views

Not a Member yet?

Ask to Folks Login

My Account
278 Folks are online
0 members and 278 guest online
Your feedback is highly appreciated