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