Help needed tweaking the "randbetween" function

[Ed]

I am using the following “Random Between” formula, “=randbetween
(0,1).” As expected, I’m getting “0” approximately 50% of the time and
“1” approximately 50% of the time. Is there a way in Excel 2008 that I
can get the results to be a little less random; say get “0” 53% of the
time and “1” 47% of the time?

Thanks,

Ed

 

[Mike Middleton]

Ed -

=IF(RAND()<=0.53,0,1)

- Mike
http://www.MikeMiddleton.com



I am using the following “Random Between” formula, “=randbetween
(0,1).” As expected, I’m getting “0” approximately 50% of the time and
“1” approximately 50% of the time. Is there a way in Excel 2008 that I
can get the results to be a little less random; say get “0” 53% of the
time and “1” 47% of the time?

Thanks,

Ed

 

[Ed]

One way:

   =--(RAND()>0.53)

The double unary negative ("--") coerces the TRUE/FALSE generated by the

Thank you Mile and thank you JE. Your solution are very helpful.

Ed

 

[JE McGimpsey]

I am using the following ³Random Between² formula, ³=randbetween
(0,1).² As expected, I¹m getting ³0² approximately 50% of the time and
³1² approximately 50% of the time. Is there a way in Excel 2008 that I
can get the results to be a little less random; say get ³0² 53% of the
time and ³1² 47% of the time?

One way:

=--(RAND()>0.53)

The double unary negative ("--") coerces the TRUE/FALSE generated by the