Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with multiple options alphanumeric
Hello everyone,
Hoping someone can help me with this one - it has me stumped. I have a spreadsheet that has an overall category in row 3, with subcategories under in rows 4 through 10 In cells B4:B10 are alpha values: "Level 1", "Level 2", or "Level 1&2" Here is what I would like to appear in cell B3: If "Level 1&2" appears anywhere in B4:B10, returns "Level 1&2" If "Level 1" and "Level 2" appear over the range B4:B10, returns "Level 1&2" If only "Level 1" appears anywhere over range B4:B10, returns "Level 1" If only "Level 2" appears anywhere over range, returns "Level 2" Does anyone know a formula that will work for this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple options- answer in single cel | Excel Discussion (Misc queries) | |||
Using Multiple Options to Define Outputs | Excel Discussion (Misc queries) | |||
same options for multiple charts | Charts and Charting in Excel | |||
Data Validation - Multiple Options | Excel Discussion (Misc queries) | |||
parameter query - multiple options | Excel Discussion (Misc queries) |