IF

[Guest]

What is wrong with this function?
=IF(Recap!A1=C112,1,0)

What I'm trying to do if I type in C112 into cell A1 then the selected cell
which is on another worksheet in the same book is equal to 1 then if not then
equal to 0.

Thanks

 

[Guest]

Hi,

its treating C112 as an adress so put it in quotes.

=IF(Recap!A1="C112",1,0)

mike

 

[Guest]

Mike , I had tried that it didn't work. Also tried hypnes.
Even on the dialoge box it says false.

 

[Guest]

I just recreated Mike's suggestino and it worked. Verify each charater to
make sure that it is what you think and the case is the same (C112 does not
equal c112)

 

[Guest]

Mike, I got it. The format of the A1 cell was not TEXT it was on number. Once
I changed it to text it worked.

Thanks