IF AND Syntax

[gg]

Good Afternoon,
I have a project that requires a grading score based on several criteria. I have to return a "A", "B", "C" or "D" if certain conditions are met.

I have no idea what the syntax should be?

There are 3 criteria's and 4 grades that can be applied.

Criteria 1 Criteria 2 Criteria 3
A <=15 A= 0 A=0
B = 16-100 B = 0 B=1
C = 101-500 C = 1 C=2-5
D > 500 D = >1 D>=5

As mentioned above. I have to return an overall letter grade based on performance measurements of the three criteria.

Does anyone have any idea how to do this?

 

[Scott Huish]

How can B be 16-100 and 0 and 1? Can you please provide a sample and expected results?

 

[shg]

The first one is easy enough:

	A​	B​	C​
1​	Number​	Letter​
2​	0​	A​	B2: =MID("ABCD", MATCH(A2, {0,16,101,501}), 1)
3​	15​	A​
4​	16​	B​
5​	100​	B​
6​	101​	C​
7​	500​	C​
8​	501​	D​

I don't understand the others.