Ron,

I had a mindset about changing false/true to 0 or 1 and then adding the 1
the OP wanted and failed to realise the +1 would do both jobs.

Thanks for pointing that out.

Mike

"Ron Rosenfeld" wrote:

On Sat, 7 Feb 2009 04:38:01 -0800, Mike H
wrote:

=(A1=B1)*1+1

The *1 seems to be superfluous.

=(A1=B1)+1



--ron