need more than seven if statements

[robt]

I know i can only nest seven if statements in excel. Trouble is i have 12 conditions! any help much appreciated

cheers
rob

 

[just_jon]

Here is one approach --

Number grades here -- as many students as needed, 1 per row:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Student	Math	History	Science	Arts	Chemistry	Music	PhyEd	French	Sociology	CmptrSci	Spelling	Penmanship
2	Bloggs,Joe	1.3	1.5	2.3	2.5	4.0	3.4	5.2	7.5	7.0	6.5	6.0	5.5
3	Jon,Just	8.0	7.0	6.0	5.0	4.0	3.0	2.0	4.7	2.5	1.3	3.3	7.3
Sheet1

Converted to letter grades here:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Student	Math	History	Science	Arts	Chemistry	Music	PhyEd	French	Sociology	CmptrSci	Spelling	Penmanship
2	Bloggs,Joe	G	G	F/G	F/G	F	F	F/S	E	S/E	S/E	S	S
3	Jon,Just	E	S/E	S	F/S	F	F/G	G	F/S	F/G	G	F	E
Sheet2

Based upon this lookup table:

Book1
	A	B	C	D
1	Score	LtrGrade
2	1.30	G
3	2.30	F/G
4	3.30	F
5	4.30	F/S
6	5.30	S
7	6.30	S/E
8	7.30	E
9	8.30	E+
Sheet3

 

[Aladin Akyurek]

Two choices...

1a) Create an additional row for each pupil and apply the VLOOKUP formula or...
1b) Recreate the pupil by subject matrix in another worksheet and establish the grades using VLOOKUP formulas.
2) Ask for a macro that replaces the existing scores with corresponding grades in place.

 

[RalphA]

It has been my experience that, for understanding, it usually takes three or more communications, plus an actual file to relate to, in order to arrive at a final solution to almost any problem.

You have now received at least three good solutions for your stated problem. I feel that, if you still don't think you have a viable solution, you should proceed either to post a complete example of your spreadsheet, or, otherwise, contact the person you think has what appears to be the best solution for you, and send that person a copy of your spreadsheet.

I post the above, with the good intention of helping all concerned.