It's hard to tell what you're doing since you didn't include the
formulae, but this might be of help:

http://www.mcgimpsey.com/excel/randint.html

In article ,
comotoman
wrote:

I wrote if staements for a random number generator, yet they dont work
with the random number generator. All I am trying to do is make sure
two of the same numbers do not show up. Without the rand. the formulas
work fine. HELP!!!!