If formula to put three values in cell based on value of anther cell

[Swissmiss]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Score[/TD]
[TD]Rating[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]80[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What formula do I use to get the rating to show up as Below, Approaches, Met, Masters based on the following:

If score is 40 or less equals below
If score is between 41 & 62 equals Approaches
If score is between 63 & 78 equals Met
If score is 79 or higher equals Masters

Thanks!

 

[dreid1011]

Two options:

Hard coded formula:

=LOOKUP(A3,{0,41,63,79},{"Below","Approaches","Met","Masters"})

Or Lookup Table:

=LOOKUP(A3,$E$3:$E$6,$F$3:$F$6)
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]E
[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0[/TD]
[TD]Below[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]41[/TD]
[TD]Approaches[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]63[/TD]
[TD]Met[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]79[/TD]
[TD]Masters[/TD]
[/TR]
</tbody>[/TABLE]

 

[Swissmiss]

Worked perfectly! Thank you!

 

[dreid1011]

You're welcome, and thank you for the feedback.