If range (i.e value 0-39 display Does not meet)

[lastingimprint02]

I'm creating a scoresheet and the grand total score at the bottom needs to correspond to a legend.
The legend would be the following:
0-39 = Does Not Meet
40-60 = Progressing Towards Goal
61-120 = Meets Goal
121-140 = Exceeds Goal

If someones grand total score was say 50, I would like it to display adjacent to the score "Progressing Towards Goal".

Can anyone assist? I have very basic excel skills so as much detail as possible in your response would be most helpful. Thanks!

 

[Ruddles]

Place this next to the total score and change the A1 to point at the total score:-

=CHOOSE(MATCH([COLOR=red][B]A1[/B][/COLOR],{0,40,61,121},1),"Does Not Meet","Progressing Towards Goal","Meets Goal","Exceeds Goal")

 

[lastingimprint02]

Works perfect! Thank you so much, I would have never figured it out on my own!