Random numbers from several ranges

[ChrisSafety]

How can I set up one formula to randomly give me a number from multiple
ranges? For example, I have 2 ranges. One is 105 though 128 and the other is
244 through 286. I need to randomly select one number from either range. I
have tried the =RANDBETWEEN function, but I can't get it to work for multiple
ranges. Please help! Thank You
Chris

 

[John C]

You could set up multiple randbetween statements with an IF statement.

If each range is weighted equally:

=IF(RANDBETWEEN(1,2)=1,RANDBETWEEN(105,128),RANDBETWEEN(244,286))

If each possibility in each range is weighted equally:

=IF(RANDBETWEEN(1,67)<25,RANDBETWEEN(105,128),RANDBETWEEN(244,286))

 

[ChrisSafety]

Thank you so much! It worked perfectly!

You could set up multiple randbetween statements with an IF statement.

If each range is weighted equally:

=IF(RANDBETWEEN(1,2)=1,RANDBETWEEN(105,128),RANDBETWEEN(244,286))

If each possibility in each range is weighted equally:

=IF(RANDBETWEEN(1,67)<25,RANDBETWEEN(105,128),RANDBETWEEN(244,286))

 

[Jarek Kujawa]

1. have you tried to use named ranges?

in Excel 2003 Insert->Name->Define

2. another option might be:
http://www.tushar-mehta.com/excel/tips/multi_area_argument.html