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

Popular Categories





how to use random function in excel?

+1 vote
92 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,845 views
asked in Programming by krish Expert (6,310 points)
+3 votes
1 answer 410 views
+1 vote
2 answers 5,692 views
+1 vote
1 answer 3,373 views
0 votes
0 answers 181 views
asked in Programming by vimal jain
+1 vote
0 answers 33 views
+6 votes
3 answers 7,003 views
+4 votes
1 answer 1,000 views
0 votes
0 answers 174 views

Not a Member yet?

Ask to Folks Login

My Account
446 Folks are online
2 members and 444 guest online
Your feedback is highly appreciated