Jesse,

Another thought, there are literally tens of millions of random numbers
between 1 and 6 so you have a better chance of winning the lottery than
hitting exactly 3 and getting a YES in B3.

Mike
Mike

"Mike H" wrote:

Jesse,

It doesn't, it displays Yes when b2 = 3 so there is something wrong with the
way you are seeing B2.

As a start try this. Delete the formula from B2, format the cell as general
and enter the number 3. Does B3 change to yes? If it does then out your
formula back in B2 and it should work.

Mike

"Jesse CH" wrote:

I am using Excel 2000, and I cannot get RAND and IF functions to work
together properly.
For example, B2 is =RAND()*(6-1)+1 to generate a random number between 1 and
6.
B3 is =IF(B2=3,"Yes") to return the value Yes if B2 is 3.
But B3 always returns "FALSE" instead of any other value, even if B2 is 3.

--
-Jesse CH