Number intervals - positive to negative

[froggeja]

I have six columns and 15,625 rows. My data is working with combinations of +2 to -2.

In column A, I want to sequence my input data as +2,+1,0,-1,-2 and then repeat until row 15,625

In column B, I want to sequence it as five +2s, then five +1s, then five 0s, then five -1s, then five -2s.

In column C, I want to sequence it as 25 +2s, then 25 +1s, then 25 0s, then 25 -1s, then 25 -2s.

In column D, I want to sequence it as 125 +2s, then 125 +1s, then 125 0s, then 125 -1s, then 125 -2s.

In column E, I want to sequence it as 625 +2s, then 625 +1s, then 625 0s, then 625 -1s, then 625 -2s.

In column F, I want to sequence it as 3,125 +2s, then 3,125 +1s, then 3,125 0s, then 3,125 -1s, then 3,125 -2s.

This will create a permutations matrix of 15,625 outcomes of six questions with 5 answers each.

I think I need to modify these formulas:
=MOD(ROWS($A$1:$A1)-1,5)+1
=MOD((INT((ROWS($A$1:$A1)-1)/5)+1)-1,5)+1
=MOD((INT((ROWS($A$1:$A1)-1)/25)+1)-1,5)+1
=MOD((INT((ROWS($A$1:$A1)-1)/125)+1)-1,5)+1
=MOD((INT((ROWS($A$1:$A1)-1)/625)+1)-1,5)+1
=MOD((INT((ROWS($A$1:$A1)-1)/3125)+1)-1,5)+1


Hope you can help!

[samba_ravi]

attach a sample file with expected result

[froggeja]

See attached.Book 4.xlsx

[froggeja]

Try wrapping each of your formulas within a LOOKUP() as follows:
=LOOKUP(YourFormula,{1,2,3,4,5},{-2,-1,0,1,2})

[samba_ravi]

See the attached file