eliW
Well-known Member
- Joined
- Mar 2, 2002
- Messages
- 1,940
On 30/3 Chris Davison posted a question in:
http://www.mrexcel.com/board/viewtopic.php?topic=3699&forum=2&start=0
It was answered by using a single formula.
Now how can it be done for 3 ranges of numbers, say: 1-10, 21-30, 51-60, in one single formula?
Eli
This message was edited by eliW on 2002-04-01 07:49
http://www.mrexcel.com/board/viewtopic.php?topic=3699&forum=2&start=0
Evening all,
how can I return a single random number from the set : 1 to 10 and 20 to 30
ie
8 would be okay
2 would be okay
23 would be okay
29 would be okay
but 15 would not be okay
and 18 would not be okay
Just one random number from those ranges 1-10, 20-30
It was answered by using a single formula.
Now how can it be done for 3 ranges of numbers, say: 1-10, 21-30, 51-60, in one single formula?
Eli
This message was edited by eliW on 2002-04-01 07:49