Letter Grades

[CalebC]

I need some help, I am attempting to create a letter grade based off 7 criteria and wheter they are passing or failing.

I currently have 7 different measures that come out with the same results as this, 

I want to combine the 7 measures and have 

IF

7=Pass then "A"

6 = Pass then "B"

5 =Pass then "B"

4=Pass then "D"

0-3= Pass then "F"

Any help would be appreciated! 

Thanks, 

[Greg_Deckler · Accepted solution]

Seems like what you want is to use a SWITCH statement.

https://msdn.microsoft.com/en-us/library/gg492166.aspx