How is Excel meant to know which one or two subjects to upgrade?

[nskatoch]

How is Excel meant to know which one or two subjects to upgrade?

In the following table I want to upgrade the subjects which has lower grade as per given condition in the "C" column.

IF lower grade is A2 to then upgrade to A1,
IF lower grade is B1 to then upgrade to A2,
IF lower grade is B2 to then upgrade to B1,
IF lower grade is C1 to then upgrade to B2,
IF lower grade is C2 to then upgrade to C1,
IF lower grade is D to then upgrade to C2,
IF lower grade is E1 to then upgrade to D,
IF lower grade is E2 to then upgrade to E1.

A	B	C	D	E	F	G	H	I	J	K
S.N	Name	UPGRADATION	ENG	UPGRADE	SCI.	UPGRADE	MATH	UPGRADE	S.S.	UPGRADE
1	MAM	Upgradation in two subjects	B1		B1		A2		A1
2	TOM	NO Upgradation	A1		A1		A2		A2
3	SAM	Upgradation in one subject	D		A2		A2		C1

<tbody>
</tbody>

 

[oldbrewer]

IF lower grade is A2 to then upgrade to A1,

IF lower grade is B1 to then upgrade to A2,

IF lower grade is B2 to then upgrade to B1,

IF lower grade is C1 to then upgrade to B2,

IF lower grade is C2 to then upgrade to C1,

A1

A1

IF lower grade is D to then upgrade to C2,

A2

A1

IF lower grade is E1 to then upgrade to D,

B1

A2

IF lower grade is E2 to then upgrade to E1.

B2

B1

C1

B2

A

B

C

D

E

F

G

H

I

J

K

C2

C1

S.N

Name

UPGRADATION

ENG

UPGRADE

SCI.

UPGRADE

MATH

UPGRADE

S.S.

UPGRADE

D

C2

1

MAM

Upgradation in two subjects

B1

B1

A2

A1

E1

D

2

TOM

NO Upgradation

A1

A1

A2

A2

E2

E1

3

SAM

Upgradation in one subject

D

A2

A2

C1

MAM - upgrade in 2 subjects - how are you choosing which 2

it looks like A2 and A1 cannot be upgraded

yet your rules say upgrade A2 to A1

<colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>

 

[StephenCrump]

Reposted from here (but no clearer) ... http://www.mrexcel.com/forum/excel-...-their-higher-level-per-given-conditions.html

 

[nskatoch]

IF lower grade is A2 to then upgrade to A1,

IF lower grade is B1 to then upgrade to A2,

IF lower grade is B2 to then upgrade to B1,

IF lower grade is C1 to then upgrade to B2,

IF lower grade is C2 to then upgrade to C1,

A1

A1

IF lower grade is D to then upgrade to C2,

A2

A1

IF lower grade is E1 to then upgrade to D,

B1

A2

IF lower grade is E2 to then upgrade to E1.

B2

B1

C1

B2

A

B

C

D

E

F

G

H

I

J

K

C2

C1

S.N

Name

UPGRADATION

ENG

UPGRADE

SCI.

UPGRADE

MATH

UPGRADE

S.S.

UPGRADE

D

C2

1

MAM

Upgradation in two subjects

B1

B1

A2

A1

E1

D

2

TOM

NO Upgradation

A1

A1

A2

A2

E2

E1

3

SAM

Upgradation in one subject

D

A2

A2

C1

MAM - upgrade in 2 subjects - how are you choosing which 2

it looks like A2 and A1 cannot be upgraded

yet your rules say upgrade A2 to A1

<tbody>
</tbody>

Thank you for reply, In above table only that grade will upgrade which are low(i.e. MAM has Secured B1,B1,A2,A1. So he has secured B1,B1 in Eng and Math.
But SAM has secured D,A2,A2,C1 as per condition only one grade will be upgraded (i.e. D in Eng. subject)
Please solve my problem.

 

[oldbrewer]

But SAM has secured D,A2,A2,C1 as per condition only one grade will be upgraded (i.e. D in Eng. subject)
Please solve my problem.

why is the C1 not upgraded ?