I need to create what I would think would be an IF formula for quite a large
group of measurements. Here is an example of what I am working with...

A B
Score Rating
55%

Here are the measurements below of how column B would reflect
NM = <50
MS = 50-52.9
ME = 53 -55.9
FE = 56-59.9
SE = or 60

Any easy ideas with the formula to use?