Randbetween

**ASPENCO** · 07-03-2013, 12:30 AM

I would like to generate an integer that is either between 1 and 100 or 200 and 300. Thank you in advance for your assistance.

**Ace_XL** · 07-03-2013, 12:44 AM

Try

=CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(1,100),RANDBETWEEN(200,300))

**ASPENCO** · 07-03-2013, 12:59 AM

Thank you that seemed to work perfectly.

**benishiryo** · 07-03-2013, 12:55 AM

hi ASPENCO. wow a maiden post after 10 years! an alternative:
=CHOOSE(RANDBETWEEN(1,4),1,100,200,300)

**Ace_XL** · 07-03-2013, 01:33 AM

@ Benishiryo

=CHOOSE(RANDBETWEEN(1,4),1,100,200,300)

gives either 1,100,200 or 300

Am I missing something?

**benishiryo** · 07-03-2013, 01:45 AM

@ Ace_XL:
oops you're right. i thought OP wanted random figures between the 4 numbers.

@ASPENCO:
please mark thread as "Solved" if the solution solved the problem

**Debraj Roy** · 07-03-2013, 01:54 AM

Hi ASPENCO..

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

http://chandoo.org/forums/topic/randbetween

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