Having trouble developing this formula

voilette83

New Member
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

MrExcel MVP
I would suggest using a LOOKUP

Code:
``=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

New Member
Thanks!

Works like a charm!

1,081,560
Messages
5,359,609
Members
400,538
Latest member
leon_oscar

This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...