RANDBETWEEN generating numbers outside range

[Penny Black]

Using Excel 2003. Simple task of trying to generate a pseudo-random number
between 1 and 52 (yes, a deck of cards). I'm populating the cells with
=RANDBETWEEN(1,52). Many of the cells are displaying negative numbers.

Any ideas?

 

[Fred Smith]

Are you sure that's exactly the formula you are using?

I entered =randbetwwen(1,52), filled it down 51 times, and got the expected
results: a bunch of numbers between 1 and 52, none negative.

Regards,
Fred

 

[Gord Dibben]

I cannot replicate this in 2003.

I get all positives between 1 and 52.

I dragged down for 1000 rows and recalculated many times.

No negatives.

I can't think of a reason why you get negatives unless you have typed
negative top and/or bottom parameters.

Your example formula does not show that however.


Gord Dibben MS Excel MVP

 

[Stephen Bye]

The RAND function returns negative numbers in Excel 2003
http://support.microsoft.com/kb/834520

 

[Gord Dibben]

Thanks for the link Stephen.

Do you know if this problem also relates to RANDBETWEEN function?

Doesn't specifically state so but maybe??

I guess OP installing the hotfix wouldn't hurt.


Gord

 

[Mike Middleton]

Penny Black -

My ideas are the same as I posted in the microsoft.public.mac.office.excel
newsgroup:

(A) Early Excel 2003 had a serious bug in its random number generator. Be
sure to update to Excel 2003 SP3.

(B) You may want to avoid duplicates, in which case search Bing or Google
for "excel unique random numbers" (without the quotes).

- Mike
http://www.MikeMiddleton.com