| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF OR problem
Not sure where to start with this formula but I need a single formula that
results in multiple possible answers. Here is what I have If E3 = "U6" then 120 or = "U8" then 150 or = "U10" or "U12" or "U14" or "U16" and G3 = com then 350 or = "U10" or "U12" or "U14" or "U16" and G3 = dev then 380 or = "U10" or "U12" or "U14" or "U16" and G3 = Tier then 410 or = "U18" then 375 Cell E3 could have 7 possible entries and cell G3 could have 3 possible entries The answer needs to be 120 or 150 or 350 or 380 or 410 or 375 This all needs to be in one formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| big problem | Excel Discussion (Misc queries) | |||
| xla problem | Excel Discussion (Misc queries) | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| #N/A problem | Excel Worksheet Functions | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Threaded Mode
