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
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