Randomly Choose Two Numbers

[Dennis]

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??

 

[Biff]

Try this:

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

Biff

 

[Mike Middleton]

Dennis -

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

- Mike
http://www.mikemiddleton.com