Help with IF Statement

[edam4i]

How do I get to check two cells if they match and then return a value?

I'm using an Id Statement but it's working for 2 out of 3 scenarios.

=IF(A1=B1,1,0)

A1 B1 C1
HAM HAM 0
BEEF BEEF 1
TURKEY TURKEY 1

The If Statement works on BEEF=BEEF and TURKEY=TURKEY but not HAM=HAM?

Please help!
Colin

 

[Joyner]

Not that this will solve your problem, but if you are actually entering only 1, 2, or 3 you could use:

=CHOOSE(A1+1,"","Ham","Turkey","Beef")


and the IF statement can deal with numbers or letters, so I'm still not getting a sense of your problem

What do you mean by this:

When I input words instead of numbers and match everything works fine but I need to use a mixture so maybe the IF Statement isn't suitable?
any suggestions?

Can you explain?

Make sure if you are entering a number in a formula do not put it in quotes i.e. "1" unless you want it to be text

 

[Joyner]

Of course using your example this should be:

=CHOOSE(A1+1,"","Ham","Beef","Turkey")

 

[jtakw]

=IF(A1=1,"Ham",IF(A1=2,"Turkey","Beef"))

How did the number (1, 2, etc.) get in A1?

In an unused cell, put =ISNUMBER(A1)

What do you get?