# Trying to create a coin toss

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