Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Calc: using Randbetween

I want random numbers between minus 3 and plus 3. Is there any difference between:

=RANDBETWEEN(-3,3)

or

=RANDBETWEEN(0,6)-3

I've been using the latter but it seems like I'm getting more positives than negatives, in fact twice as many positives. That could be just chance but I've run 720 trials so the sample seems large enough.

Thanks for any help.

Mike S.