Randomly Choose Two Numbers
 

I have number 2 in column A and i would like to know if there is a formula
which can choose number 1 or 3 randomly in column B. I've tried
RANDBETWEEN(1,3) but it chooses 1, 2 or 3, and i only want to choose a 1 or
3, can anyone help me out??
--
D-Rock

Randomly Choose Two Numbers
 

Try this:

=LOOKUP(RANDBETWEEN(1,4),{1,3})

Biff

"Dennis" wrote in message
...
I have number 2 in column A and i would like to know if there is a formula
which can choose number 1 or 3 randomly in column B. I've tried
RANDBETWEEN(1,3) but it chooses 1, 2 or 3, and i only want to choose a 1
or
3, can anyone help me out??
--
D-Rock

Randomly Choose Two Numbers
 

Dennis -

If you want 1 or 3 to be equally-likely, use =IF(RAND()<0.5,1,3) in column
B.