How do I Provide a specific result given multiple criteria?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to setup a function that will check to see if multiple criteria is
met given three different cells. To be more clear.

I have three columns A, B, C and three different criteria.
If a cell in column A=100, and Column B>=95, and Column C>=90 then the
response is Platinum.
but
If the cell in Column A=100, and Column B>=92 but below 95, and Column C=>85
but below 90 then the response is Gold.

Can someone provide some help with this one?

Thanks
 
This should get you part of the way

=IF(AND(A1=100,B1>=95,C1>=90),"PLATINUM","")

If you can't get the rest of it, come back.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIFS, one criteria range, multiple criteria 3
Access Dcount (multiple criteria) 3
Lookup multiple cell values and place contents in a single cell 3
Determine Value based on criteria 1
How to concatenate cells that meets a specific criteria in threecolumns 6
Multiple Criteria Sum 8
Multiple criteria search 2
countifs Function not giving desired result with date criteria 2

Back
Top