Impossible Formula!

[Filmmaker]

This is a complicated need I have and the formula seems impossible bu
if there is a wizard out there who can tackle this I would greatl
appreciate any help. Here is my quandry:
I have one of five values in cell A1; "Red", "Blue"
"Green","Yellow" or "Orange". I have one of two values in cell B1
"Chevy" or "Ford".

If A1 contains "Red", "Blue" or "Green" and B1 contains "Chevy"
need C1 to automatically show the value 1000.
If A1 contains "Red", "Blue" or "Green" and B1 contains "Ford" I nee
C1 to automatically show the value "2000."
If A1 contains "Yellow" or "Orange" and B1 contains "Chevy" I need C
to show the value "3000".
If A1 contains "Yellow" or "Orange" and B1 contains "Ford" I need C1 t
show the value "4000".

Again, any help is appreciated

 

[Frank Kabel]

Hi
not tested but try one way:
=IF(OR(A1="Red",A1="Blue",A1="Green"),IF(B1="Chevy",1000,IF(B1="Ford",2
000,"Not
defined")),IF(OR(A1="Yellow",A1="Orange"),IF(B1="Chevy",3000,IF(B1="For
d",4000,"Not defined"))))

 

[BenjieLop]

This is a complicated need I have and the formula seems impossible but
if there is a wizard out there who can tackle this I would greatly
appreciate any help. Here is my quandry:
I have one of five values in cell A1; "Red", "Blue",
"Green","Yellow" or "Orange". I have one of two values in cell B1;
"Chevy" or "Ford".

If A1 contains "Red", "Blue" or "Green" and B1 contains "Chevy" I
need C1 to automatically show the value 1000.
If A1 contains "Red", "Blue" or "Green" and B1 contains "Ford" I need
C1 to automatically show the value "2000."
If A1 contains "Yellow" or "Orange" and B1 contains "Chevy" I need C1
to show the value "3000".
If A1 contains "Yellow" or "Orange" and B1 contains "Ford" I need C1 to
show the value "4000".

Again, any help is appreciated.

I have a formula that will help you ... it may not be elegant but it
works (as I tested it):

IF(AND(OR(A1="Red",A1="Blue",A1="Green"),B1="Chevy"),1000,IF(AND(OR(A1="Red",A1="Blue",A1="Green"),B1="Ford"),2000,IF(AND(OR(A1="Yellow",A1="Orange"),B1="Chevy"),3000,IF(AND(OR(A1="Yellow",A1="Orange"),B1="Ford"),4000,""))))

 

[Arvi Laanemets]

Hi

Another one (I think it's easier to follow, and easier to expand when
needed)
=OR(A1="Red",A1="Blue","Green")*((B1="Chevy")*1000+(B1="Ford")*2000)+OR(A1="
Yellow",A1="Orange")*((B1="Chevy")*3000+(B1="Ford")*4000)


Arvi Laanemets

 

[Arvi Laanemets]

Sorry, a typo!

=OR(A1="Red",A1="Blue","A1=Green")*((B1="Chevy")*1000+(B1="Ford")*2000)+OR(A
1="Yellow",A1="Orange")*((B1="Chevy")*3000+(B1="Ford")*4000)


Arvi Laanemets

 

[Aladin Akyurek]

=VLOOKUP(A1&B1,{"RedChevy",1000;"BlueChevy",1000;"GreenChevy",1000;"RedFord",2000;"BlueFord",2000;"GreenFord",2000;"YellowChevy",3000;"OrangeChevy",3000;"YellowFord",4000;"OrangeFord",4000},2,0)