Hi,

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

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

mike

"dpal" wrote:

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