Using IF statement for Letter Sequences

[macdadi112]

Hi,

I cannot get my head round letter sequences (seriously I've tried)

What you have is the full alphabet and increasing in value I can do..

e.g. D ,G, J, M, P (You will start the alphabet again if you reach the end).

What I'm pulling my hair on is going backwards especially when you have to start all over again.

e.g I, D, Y, T, O

What I was thinking something along the line of:

IF(65+C14+(3*D14)<=90,CHAR(65+C14+(3*D14)),CHAR(65+((C14+(3*D14))+65)-91))

The following are found in C14 and D14,..

rnd no seq no
20 5

The above are generated at random.

Hope you guys can help..

[teylyn]

I have no idea what you are trying to achieve. Can you explain?

[macdadi112]

LOL

What I'm trying to do is output the letters of the alphabet..

They can start at any letter and then they increase/decrease by a random number(1-5).

Lets say the first letter output is I..

Then counting back in the alphabet we have H,G,F,E

The second letter output is D.

[I]Then counting back in the alphabet we have C,B,A,Z[/]

The third letter output is Y.

E.t.c.

Hope the above makes sense..

[Ace_XL]

Is this what you're looking for?

[Jonmo1]

Give this a whirl

LetterSeries.xlsx

[shg]

Maybe ...

Row\Col	A	B	C
1	0	A	B1: =CHAR(MOD(A1,26) + 65)
2	5	F	B2 and down: =CHAR(MOD(CODE(B1) - 65 + A2, 26) + 65)
3	5	K
4	2	M
5	9	V
6	6	B
7	8	J
8	10	T
9	7	A

[macdadi112]

Wow.. Thanks guys for taking a look..

Is this what you're looking for?

Thats the closest one that I got.

It works for adding on the alplhabet..

What I require is one for...

What I'm trying to do is output the letters of the alphabet..

They can start at any letter and then they increase/decrease by a random number(1-5).

Lets say the first letter output is I..

Then counting back in the alphabet we have H,G,F,E

The second letter output is D.

[I]Then counting back in the alphabet we have C,B,A,Z[/]

The third letter output is Y.

E.t.c.

[shg]

Row\Col	A	B	C
1		I	B1: Input
2	5	D	B2 and down: =CHAR(MOD(CODE(B1) - 65 - A2, 26) + 65)
3	5	Y
4	1	X
5	1	W