Excel 2000, RAND and IF functions do not work together for me
So whether the cell is formatted to 0 decimal places or not, the IF function
checks all decimals. Dang. Thank you, though.
--
-Jesse CH
"Mike H" wrote:
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
|