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

[Swissmiss]

Score	Rating
80
45

<tbody>
</tbody>

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)

	E	F
3	0	Below
4	41	Approaches
5	63	Met
6	79	Masters

<tbody>
</tbody>

 

[Swissmiss]

Worked perfectly! Thank you!

 

[dreid1011]

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