Cannot wrap my brain around this formula!

[jfobes]

Here is what I would like to do

If H2 is <85 “Marksman” if H2 is 85 – 89.99 “Sharpshooter” if H2 is 90 – 94.99 “Expert” if H2 is 95 – 96.99 “Master” if H2 is equal to or >97 “High Master”

All the numbers are a percentage based on another calculation to determine classification or grade

Any help would be greatly appreciated….

Thanks

 

[VoG]

Try

=LOOKUP(H2,{0,85,90,95,97},{"Marksman","Sharpshooter","Expert","Master","High Master"})

 

[jfobes]

Not working but thanks for the effort. This only populated the text if the number was exact, not a range 85 to 89.99

 

[VoG]

If your numbers are percentages then

=LOOKUP(H2,{0,0.85,0.90,0.95,0.97},{"Marksman","Sharpshooter","Expert","Master","High Master"})

 

[jfobes]

That fixed it, sorry I did not state % in the initial post.

Thanks