Jesse,

See my other reply, you never will, there are just too many numbers between
1 and 6 for it to be likely you will ever hit any integer let alone the one
you want 3.

Mike

"Jesse CH" wrote:

When the cell B2 is reformatted to general and the number 3 is entered, I do
indeed see Yes. However, when I put the RAND function back in to B2, it still
returns as FALSE. I have formatted the cell as Number with 0 decimal places,
does that matter? I've also tried formatting individual and all cells as
general and number.
--
-Jesse CH


"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