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