Filling even or odd numbers into a chart

[Hereck]

I am trying to fill in some numbers across the top row, and have the four cells below those numbers fill in as every other odd or even single digit number. That's hard to explain I'll attach a picture.


Capture.PNG

[Hereck]

Maybe this will help explain. The numbers I enter into the top row, should automatically fill in the 4 cells below it. With odd numbers if the initial entry was odd or even numbers if the initial entry was even. It should use only single digit numbers and not the number that was initially used.

example

3 2 5 9 6 8 2

5 4 7 1 8 0 4
7 6 9 3 0 2 6
9 8 1 5 2 4 8
1 0 3 7 4 6 0

[Hereck]

I figured it out. I will post my solution in case it helps anyone else.

=IF(J1=0,2,IF(J1=1,3,IF(J1=2,4,IF(J1=3,5,IF(J1=4,6,IF(J1=5,7,IF(J1=6,8,IF(J1=7,9,IF(J1=8,0,IF(J1=9,1))))))))))