Basic idea is two binaries. Column A high or low 0(1-4) or 1(6-9). Column B even or odd. Column C choices for random. Column D random number from choices in Column C.
Trying to get Column C to read one of 4 choices 1,3 or 2,4 or 7,9 or 6,8.
Trying to get Column D to pick a choice in Column C.
=IF(AND(0=A2,0=B2),“1,3”,"") Formula A will work returns 1,3 or nothing
=IF(AND(0=A2,0=B2),“1,3”,=IF(AND(0=A2,1=B2),“2,4”)) Formula B does not work returns Err:510 expected 1,3 or 2,4 or FALSE
=IF(AND(0=A2,0=B2),“1,3”),=IF(AND(0=A2,1=B2),“2,4”),=IF(AND(1=A2,0=B2),“7,9”),=IF(AND(1=A2,1=B2),“6,8”) Formula C does not work returns Err:509 expected 1,3 or 2,4 or 7,9 or 6,8
Example
1 A B C D
2 0 1 Formula C =RAND(C2)
3 1 1 6,8 6
4 0 1 2,4 4
5 0 0 1,3 3
6 1 0 7,9 7
7 1 0 7,9 9