# IF formula

Collumn AB on the attached "combined" sheet contains a number.

I need a formula in the neighbouring cell AC to perform the following;

IF AB(...) = 11 return "Platinum"
IF AB(..) >=9<11 return "Gold"
IF AB(..)>=7<9 return "Silver"
IF AB(...)>=6<7 return "Bronze"
IF AB (...)<6 return "Poor Performer"

Hopefully this should be fairly straight forward.
EE-combined.xlsx
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MSSQL Senior EngineerCommented:
Copy the below formula to the cell AC:2 and then drag it till the end of AC column:
``````=IF(AB2<6;"Poor Performer";IF(AB2<7;"Bronze";IF(AB2<9;"Silver";IF(AB2<11;"Gold";"Platinum"))))
``````
0
Author Commented:
This is returning an error and highlighting the first number "6" in the sequence of the formula
0
Finance AnalystCommented:
Alternatively setup a small table as per below:

0      Poor Performer
6      Bronze
7      Silver
9      Gold
1000000      Platinum

Then use a lookup formula:

=VLOOKUP(AB2,\$A\$2:\$B\$6,2)

A2:B6 being the table above.

Thanks
Rob H
0
Finance AnalystCommented:
Maybe Vitor's suggestion is not working because his locale uses the semicolon in formulae rather than a comma.

=IF(AB2<6,"Poor Performer",IF(AB2<7,"Bronze",IF(AB2<9,"Silver",IF(AB2<11,"Gold","Platinum"))))

Thanks
Rob
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

MSSQL Senior EngineerCommented:
Robmarr, check if you copied all characters. Or you can post here your Excel file so I can check it for you.
0
Commented:
EE-combined.xlsx
0
Author Commented:
Good Spot Rob,

Thanks Guys
0
MSSQL Senior EngineerCommented:
Yes, Regional Settings. For us comma it's used for decimal numbers so we need to use ';' for separate parameters.
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.