Thread: IF OR problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ksean ksean is offline
external usenet poster
 
Posts: 55
Default 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.