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
robmarr700Asked:
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.

Vitor MontalvãoMSSQL 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"))))

Open in new window

0
robmarr700Author Commented:
This is returning an error and highlighting the first number "6" in the sequence of the formula
0
Rob HensonFinance 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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

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

With commas instead:

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

Start your 7-day free trial
Vitor MontalvãoMSSQL 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
ProfessorJimJamCommented:
Please find attached.
EE-combined.xlsx
0
robmarr700Author Commented:
Good Spot Rob,

Thanks Guys
0
Vitor MontalvãoMSSQL 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.