Having trouble developing this formula

[voilette83]

Every attempt I have made at this has returned an error in the formula, and I just can not fix it.

This is what I need to populate in B1:

If the result in A1 is >125% then B1 should contain FE
If A1 is between 115% and 124% then B1 should contain EE
If A1 is between 100% and 114% then B1 should contain ME
If A1 is between 85% and 99% then B1 should contain PM
If A1 is <85% then B1 should contain FM

I have tried and IF(AND( statement, but I can't figure out the proper way to include the information so that I get the result I need.

Can anyone help me out with this? I would appreciate it a lot!

 

[DonkeyOte]

I would suggest using a LOOKUP

=IF(COUNT(A1),LOOKUP(A1,{-9.99E+307,0.85,1.00,1.15,1.25},{"FM","PM","ME","EE","FE"}),"")

You may choose to round A1 to 4 decimals of course.

 

[voilette83]

Thanks!

Works like a charm!