Randbetween

[turoksj]

I would like to be able to generate a random number that is between one range or another. For example, I would like to find a solution that would generate a number either between 1 and 100 or 200 and 300. Thank you in advance for your assistance.

 

[NARAYANK991]

Hi ,


Try this :


=IF(MOD(RANDBETWEEN(1,2),2)=0,RANDBETWEEN(1,100),RANDBETWEEN(200,300))


Narayan

 

[Debraj]

Hi turoksj..


In addition.. please also mention if you have cross-posted.. and also inform the same in all other areas..


http://www.excelforum.com/excel-general/936093-randbetween.html


Its a bad manner to cross-post without giving URL..

 

[Hui]

=RANDBETWEEN(0,100)+RANDBETWEEN(0,1)*200