Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I Provide a specific result given multiple criteria?
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 |
#2
|
|||
|
|||
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. "Luis" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |