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

Popular Categories





how to use random function in excel?

+1 vote
81 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,829 views
asked in Programming by krish Expert (6,310 points)
+3 votes
1 answer 355 views
+1 vote
2 answers 4,986 views
0 votes
1 answer 241 views
+1 vote
1 answer 2,425 views
0 votes
0 answers 137 views
asked in Programming by vimal jain
+1 vote
0 answers 18 views
+6 votes
3 answers 6,819 views
+4 votes
1 answer 839 views

Not a Member yet?

Ask to Folks Login

My Account
612 Folks are online
68 members and 544 guest online
Your feedback is highly appreciated