conditional information

[Robert99]

Hello,

my goal is to let cell B1 display:

"1" if I enter "1" into cell A1

or

"2" if I enter "11" into cell A1


how do I go about this?
thanks

[Special-K]

in B1

=IF(A1=1,1,IF(A1=11,2,"NEITHER 1 NOR 11"))

Replace "NEITHER 1 NOR 11" with whatever you want to happen if A1 is something different to 1 or 11

[Robert99]

in B1

=IF(A1=1,1,IF(A1=11,2,"NEITHER 1 NOR 11"))

Replace "NEITHER 1 NOR 11" with whatever you want to happen if A1 is something different to 1 or 11

Aah!
Great, thanks....