Paul,

You missed part of the scope of the question.

Kerry



"Paul C" wrote:

You should be able to nest your statement like this:

=IF(E3="U6",120,IF(E3="U8",150,IF(E3="u18",375,IF( G3="com",350,IF(G3="dev",380,IF(G3="Tier",410,0))) )))--

If this helps, please remember to click yes.


"ksean" wrote:

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.