Formula

[mad3]

I have a scoresheet that has letter grades in column B and A NUMBER FROM -4 TO +4 IN column C. I want to adjust the letter grades based on the number in column C. With the new letter grade in column D which is called ADJ.

Team	OFF	PIT/DEF	ADJ	HM	Pressure
Red Sox	Q	-2			K
Dodgers	Q	-4			N
Rays	O	-1			G
Rangers	Q	2			F

<tbody>
</tbody>

Help in California...

 

[jtakw]

Hi,

You didn't say How the Letter grade is to be adjusted by the Number.

 

[mad3]

Hi,

You didn't say How the Letter grade is to be adjusted by the Number.

My bad... If the number in column 'C' is a positive, the letter grade advances to R...S...T and so on. If the number is a negative, it goes backwards ... P...O...N etc.

 

[jtakw]

Here you go:

Excel 2010
	A	B	C	D	E	F
1	Team	OFF	PIT/DEF	ADJ	HM	Pressure
2	Red Sox	Q	-2	O		K
3	Dodgers	Q	-4	M		N
4	Rays	O	-1	N		G
5	Rangers	Q	2	S		F
Sheet1

Cell Formulas
Range	Formula
D2	=CHAR(SUM(CODE(B2),C2))

ADJ column formula copied down.

 

[mad3]

Here you go:

Excel 2010

	A	B	C	D	E	F
1	Team	OFF	PIT/DEF	ADJ	HM	Pressure
2	Red Sox	Q	-2	O		K
3	Dodgers	Q	-4	M		N
4	Rays	O	-1	N		G
5	Rangers	Q	2	S		F

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D2 =CHAR(SUM(CODE(B2),C2)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

ADJ column formula copied down.

Worked perfectly. Now on to the next step. Thanks so much!

 

[jtakw]

You're welcome.