Help with RAND() problem. Usinf IF and AND.

[Val4050]

Dear Forum

I would be very grateful for some help as I just cannot get the correct output from using RAND().

If I enter in any cell the following I had expected to get just 2 results. In this case just a "<5" or ">5".

What I dont understand is why there is a third. Why is the false being used?

Here I've just entered some more text for the FALSE "Why is this here?". Its probably straigthforward but I've drawn a blank and would be grateful for some help.

=IF(AND(RAND()>=0,RAND()<=0.5),"<5",IF(AND(RAND()>0.5,RAND()<=1),">5","Why is this here?"))

In short if RAND() is between 0 and 1 how do I filter the outcomes: 0-0.2; 0.2-0.4; 0.4-0.6; 0.6-0.8; 0.8-1.0 without overlaps?

Thank you in advance
V.

 

[mikerickson]

=IF(AND(RAND()>=0,RAND()<=0.5),"<5",IF(AND(RAND()>0.5,RAND()<=1),">5","Why is this here?"))

The two underlined functions are different numbers (enter =RAND() & ", " & RAND() to see what I mean)

try
=LOOKUP(RAND(),{0,0.2,0.4,0.6,0.8,1},{"0-2","2-4","4-6","6-8","8-10"})