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:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Number​

[/td][td="bgcolor:#F3F3F3"]

Letter​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

0​

[/td][td="bgcolor:#E5E5E5"]

A​

[/td][td]B2: =MID("ABCD", MATCH(A2, {0,16,101,501}), 1)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

15​

[/td][td="bgcolor:#E5E5E5"]

A​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

16​

[/td][td="bgcolor:#E5E5E5"]

B​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

100​

[/td][td="bgcolor:#E5E5E5"]

B​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

101​

[/td][td="bgcolor:#E5E5E5"]

C​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]

500​

[/td][td="bgcolor:#E5E5E5"]

C​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]

501​

[/td][td="bgcolor:#E5E5E5"]

D​

[/td][td][/td][/tr]
[/table]

I don't understand the others.