Teacher gave me homework to make out of this:
Code: Select all 1 2 3 4 5 6 7 8 9 10
1
2
3
4
5
6
7
8
9


10


Into this:
Code: Select all 1 2 3 4 5 6 7 8 9 10
1 0 0 1 1 0 0 1 1 0 0
2 0 0 1 1 0 0 1 1 0 0
3 0 0 1 1 0 0 1 1 0 0
4 0 0 1 1 0 0 1 1 0 0
5 0 0 1 1 0 0 1 1 0 0
6 0 0 1 1 0 0 1 1 0 0
7 0 0 1 1 0 0 1 1 0 0
8 0 0 1 1 0 0 1 1 0 0
9 0 0 1 1 0 0 1 1 0 0
10 0 0 1 1 0 0 1 1 0 0

By using IF formula. I Know how to make it with different formulas, but I need that one formula which would fit all. Please help.