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 not possible to include any Hyphen, colan, Semicolan & Underscore etc. It is also not possible to give numbers. )

Now I want a formula in Range B1 to B3 which gives threee different values or performs three different calculations based on the value in 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) & If 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 message appears.

=IF(A1EQMilling)0,1

Please give Help

Thanking you
G.Karthi

[Niek Otten]

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

--
Kind regards,

Niek Otten

"fitzol" <fitzol.263pmm_1144761002.4142@excelforum-nospam.com> wrote in message
news:fitzol.263pmm_1144761002.4142@excelforum-nospam.com...
>
> 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 not
> possible to include any Hyphen, colan, Semicolan & Underscore etc. It
> is also not possible to give numbers. )
>
> Now I want a formula in Range B1 to B3 which gives threee different
> values or performs three different calculations based on the value in
> 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) & If
> 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 message
> appears.
>
> =IF(A1EQMilling)0,1
>
> Please give Help
>
> Thanking you
> G.Karthi
>
>
> --
> fitzol
> ------------------------------------------------------------------------
> fitzol's Profile: http://www.excelforum.com/member.php...o&userid=33328
> View this thread: http://www.excelforum.com/showthread...hreadid=531876
>

[CLR]

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" wrote:

>
> 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 not
> possible to include any Hyphen, colan, Semicolan & Underscore etc. It
> is also not possible to give numbers. )
>
> Now I want a formula in Range B1 to B3 which gives threee different
> values or performs three different calculations based on the value in
> 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) & If
> 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 message
> appears.
>
> =IF(A1EQMilling)0,1
>
> Please give Help
>
> Thanking you
> G.Karthi
>
>
> --
> fitzol
> ------------------------------------------------------------------------
> fitzol's Profile: http://www.excelforum.com/member.php...o&userid=33328
> View this thread: http://www.excelforum.com/showthread...hreadid=531876
>
>

[fitzol]

Dear Mr.Niek Otten
Dear Mr.Vaya con Dios

Thank you for your suggesstion. It is working well.

Thank you again

G.Karthi