Using text as argument

[fitzol]

Dear Gentlemen,

I have the following problem.

I have the following list in cell range A1 to A3

Milling
Drilling
Tapping

( Note :- The text strings may differ from the above. It is no
possible to include any Hyphen, colan, Semicolan & Underscore etc. I
is also not possible to give numbers. )

Now I want a formula in Range B1 to B3 which gives threee differen
values or performs three different calculations based on the value i
cell A1 to A3.

ie - If cell A1 equals Milling then value in B1 is 1 ( or a formula)
If cell A1 equals Drilling then value in B1 is 2 (or a formula) & I
cell A1 equals Tapping then value in B1 is 3 ( or a formula).

But when I typed the following formula in Cell B1 an error messag
appears.

=IF(A1EQMilling)0,1

Please give Help

Thanking you
G.Karth

 

[Niek Otten]

=IF(A1="Milling",0,1)

 

[Guest]

Put this in B1 and copy down...........

=IF(A1="Milling",1,IF(A1="Drilling",2,IF(A1="Tapping",3,"")))

Vaya con Dios,
Chuck, CABGx3

 

[fitzol]

Dear Mr.Niek Otten
Dear Mr.Vaya con Dios

Thank you for your suggesstion. It is working well.

Thank you again

G.Karth