Having trouble developing this formula

voilette83

New Member
Joined
Jan 25, 2010
Messages
13
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
Joined
Sep 6, 2002
Messages
9,118
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.
 

Forum statistics

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

Some videos you may like

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...
Top