Convert to integer?

I need to create a random integer.

I've entered this: =RAND()*1000

But I need the raw number to be an integer and since I'm referring to the value from another cell, I can't just use cell formatting.

Is there a way to get the original random number to be an integer, no decimals?

Thanks

Answered my own question. Used this ...

=FLOOR((RAND()*1000),1)

Originally Posted by JohnLayne

Answered my own question. Used this ...

=FLOOR((RAND()*1000),1)

Hi John,

You don't need the extra ()

=FLOOR(RAND()*1000,1)

a few other examples give the same result as well

=ROUND(RAND()*1000,1) or variation on ROUND

=INT(RAND()*1000)

oldchippy