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