Formula for Calculation Excluding Values

[suciulaurentiu]

Dear forum friends,
I have a question regarding a calculation I have to make urgently and it seems I can not get to the bottom of it. Perhaps you can kindly help me out:

I have several values for MPTL Calculations in Excel and I need to exclude some models of cars, for example:

ALFA ROMEO, PORSCHE ( all models except CAYENNE) , JAGUAR - value of 4.5
AUDI (all models excep RS AND R8), BMW, LAND ROVER, MERCEDES (EXCEPT SL, SLK), PORSCHE CAYENNE - value of 3.85

I need a formula that can obtain me depending of that criteria those two values, 4.5 and 3.85
Perhaps you can help out with some pointers, I am really stuck.

 

[istiasztalos]

Hi !

Please post a sample of your table and existing formulas